Formating Date

[Gian04]

I know how to get, format and display the current date but what I cant do is to format and display a date that has been retrieved from mySQL DB. Example 2007-07-18 (YYYY-MM-DD) How will I format it to display July 18, 2007?

[dreamcatcher]

Hi Gian04,

DATE_FORMAT [dev.mysql.com] will be what you are looking for

mysql_query("SELECT DATE_FORMAT(date,'%M %d, %Y') AS new_date...

with the date in the format being your date field name.

dc

[Habtom]

$new = strtotime("2007-07-18");
echo date("F j, Y", $new);

Hab