Re: Date conversion
| From: | Brad Thomas | Date: | Wed, 14 Aug 2002 00:38:22 +0000 |
| Subject: | Re: Date conversion | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-15242@lists.php.net to get a copy of this message | ||
"Kit Kerbel" <kerbel5@hotmail.com> wrote in message
news:F222vvQ0Puz63Bma4RC00010f43@hotmail.com...
> I would like to convert 2002-04-02 00:00:00 to the format,
> 04-02-2002....or m/d/Y
>
> How would I do this?
>
> Thanx in advance,
> Kit
>
>
>
> _________________________________________________________________
> Chat with friends online, try MSN Messenger:
> http://messenger.msn.com
>
Hi.
There are two ways you can do this:
1) Extract it from the database, and then use explode(); on the data.
2) If you're using MySQL as your database, you can use the DATE_FORMAT
function within MySQL to format it.