RE: [PHP-DB] How to insert date into date field
| From: | Jennifer Goodie | Date: | Mon, 25 Aug 2003 23:13:21 +0000 |
| Subject: | RE: [PHP-DB] How to insert date into date field | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30088@lists.php.net to get a copy of this message | ||
> 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.
If you are using PHP to insert it you can just format it before sticking it
in. It gets a little more complicated if you are loading it in via LOAD
DATA INFILE or something like that. What exactly are you attempting to do?