Re: [PHP3] oracle8: correct date insert??

In article <394F9584.9B39794B@wap4.com>, data@wap4.com (Dieter Kneffel) wrote: > help, please: What is the proper format to perform an insert > of date and time information into a date field using oracle8. > > the following just does not work: 'insert into my_table ( my_date_field > )VALUES( '2000-06-20 12:05:01') > using other notation, e.g. slashes (01/01/2000) nstead of minus (as > above) works, but only on dates. > I am not able to insert date and time! the my_date_field is simply > defined as 'date' > In some manuals, I have seen a notion like ... TO_DATE() where you have > to supply the date/time as > an integer and give formatting information. Is this the only way? Check the Oracle documentation -- It's really up to Oracle to decide what to accept, not PHP... -- Richard Lynch | If this was worth $$$ to you, buy a CD US Customer Support Director | from one of the artists listed here: Zend Technologies USA | http://www.L-I-E.com/artists.htm http://www.zend.com | (this has nothing to do with Zend, duh!)