format the date pulled from MySQL DB.

[BigToque]

I've got a date field in my DB that stores dates as "yyyy-mm-dd"

When I get the results into PHP, how can I format the date as "Month dd, yyyy"? (ie: in the DB I've got "2005-1-20", I want "January 20, 2005")

[Brandoe85]

Try Date Format (http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html)

[BigToque]

DATE_FORMAT() wasn't working for me, but I got it working using date().

Thanks for the help

[marek_mar]

A good idea would be to store php's unix timestam in a INT(11) field. You could convert it to anything you want with date and add or substract hours (to get the right time in different timezones).

[Brandoe85]

Wouldn't this work?
SELECT date_format(DateField, '%M %d, %Y') from TableName;

[marek_mar]

:confused: No Idea. You tested it, right? You are relying on a DB function. If you'd like to change the DB you use it may not have that function (or it may have a different name). This is a rather advanced tip so you don't have to use it.

[Brandoe85]

Sounds good, thanks for the tip, marek_mar :)