Formatting Mysql date TO better output?

[Anon]

Hey All,

I have a mySQL date in a DB like:

year-month-day
so
2002-02-04

My question is, is there an easy way to get it to:

February 05, 2002 ??

Just want to know before I try and code my own solutions.

Thanks!

[Anon]

Use format_date:
for eg.
format_date(date_col,'%M %d, %Y)
will output your date to February 05, 2002.
%M - Month Name
%d - Day of the month
%Y - Year

[Anon]

hi guys...

i can't seem to get that format_date to work. i want to display a list of band tourdates, from today's date onward, and i want to format the date printed out like the guy does in the original question. here is part of my code:

$result = mysql_query("SELECT * FROM shows WHERE date >= CURDATE()",$db);

I call the date here:

while ($myrow = mysql_fetch_array($result)) {
printf($myrow["date"]);
}

so where do i put format_date in?

thanks,
mike