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 <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; Christopher CM Allen <[EMAIL PROTECTED]>
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:[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]
>
--
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]