Re: close browser

Thanks to all for the replies, I am looking into many options. One of which is traveling back in time and creating the table correctly.... ;p -ccma ----- Original Message ----- From: Robert V. Zwink <rzwink@microcenter.com> To: <php-general@lists.php.net>; Christopher CM Allen <callen@driver8.org> Sent: Tuesday, August 07, 2001 5:01 PM Subject: 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 > > > -- > 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 >