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

Reply via email to