Isn't that what I tried?
Jeff Oien
> Although it might be better to format the date in php, don't forget you can
> also do date formating in the select string. The date format functions for
> mySQL can me found here:
>
> http://www.mysql.com/doc/D/a/Date_and_time_functions.html
>
> Hope this helps,
>
>
>
> -----Original Message-----
> From: Jeff Oien [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 29, 2001 8:07 PM
> To: PHP-DB
> Subject: [PHP-DB] Date_Format Question
>
>
> I have a date like this in date format in MySQL
> 2001-08-29
>
> and I want it to say
> August 29, 2001
>
> I tried this and it didn't work.
> select date_format('creation_date', '%b %D, %Y') from Chart_Users;
>
> Could you tell me what I'm doing wrong or how I should do this? Thanks.
> Jeff Oien
>
> --
> PHP Database 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 Database 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]