RE: [PHP-DB] Date_Format Question

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:jeff@webdesigns1.com] > 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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >