Did you look in the manual?
http://www.php.net/manual/en/function.strtotime.php
strtotime() -- Parse about any english textual datetime description into a
UNIX timestamp
This is probably what you are looking for.
As far as converting a CHAR (assuming) type column in MySQL to DATE, I think
you would have to write php to select each row, convert the date, then
update the row with the new date. I would create a new TIMESTAMP column,
write php to select the old date, convert it, then update the row with the
new TIMESTAMP added.
Robert V. Zwink
DAID Development LLC
http://www.zwink.net/daid.php
-----Original Message-----
From: Christopher CM Allen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 4:44 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] close browser
Greetings:
I have a field entry in a MYQSL table that stores the date as:
August 02, 2001 :(
Is there anyway to convert this to 08-02-2001 outside of the table via php?
Better yet is there ayway I can go back into my table and change these dates
into a better format for computation?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
