RE: [PHP] close browser

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:callen@driver8.org] Sent: Tuesday, August 07, 2001 4:44 PM To: php-general@lists.php.net 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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net