RE: [PHP-DB] How to insert date into date field

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:goodie@apollointeractive.com] 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