load my apache access log into a table (this is formatted wrong)
I now use a workaround by adding the date that I enter the records into the
table as well. I lose the timestamp but that's ok for now.
I then wrote an update statement to convert the old data to the correct date
and just make sure that just before midnight every day I load the data.
I'll look at my PHP insert script one day to see if I can easily change this
to pre format the date field .
Jack
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]
Sent: dinsdag 26 augustus 2003 1:13
To: Jack van Zanen; Php-Db
Subject: RE: [PHP-DB] How to insert date into date field
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?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php