oracle8: correct date insert??
| From: | Dieter Kneffel | Date: | Tue, 20 Jun 2000 16:02:12 +0000 |
| Subject: | oracle8: correct date insert?? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-518@lists.php.net to get a copy of this message | ||
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