[PHP-DB] Date_Format Question

[Jeff Oien]

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]