How to insert date into date field
| From: | Jack van Zanen | Date: | Mon, 25 Aug 2003 12:24:57 +0000 |
| Subject: | How to insert date into date field | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-30084@lists.php.net to get a copy of this message | ||
Hi
I have a date that is formatted in the following way
day(00-31)/Mon(Jan-Dec)/year(2003):hour(00-23):minute(00-59):sec(00-59)
I want to load this into mysql table (date column)
In oracle I can just use the to_date function but all I find about MYSQL
seems to want the date in a specific format beforehand.
Any help??
TIA
JAck