RE: [PHP-DB] oracle8: correct date insert??

I'm pretty sure you need to use a to_date('string','format') on it. to_date('06/06/2000','MM/DD/YYYY') ...or something fairly close to that. CJ "No other personal quality contributes to success more than relentless persistence in the pursuit of one's goals." -----Original Message----- From: Dieter Kneffel [mailto:data@wap4.com] Sent: Tuesday, June 20, 2000 11:02 AM To: php3@lists.php.net; php-db Subject: [PHP-DB] oracle8: correct date insert?? 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? Please give me an example! thanks, dieter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net