date format

[Anon]

okay, this is my sql query
SELECT DISTINCT date FROM dbtable ORDER BY date DESC limit 1"

in mysql, the field is of type date, and it listed like 2002-01-08

i need to print it out like January 8, 2002. How do i do this? I tried using someting like SELECT DISTINCT DATE_FORMAT(date, "%M %e, %Y") as newdate FROM dbtable ORDER BY date DESC limit 1

but that doesn't work.

[marcel]

🙂)
replace " with '
SELECT DISTINCT DATE_FORMAT(date, '%M %e, %Y') as newdate FROM dbtable ORDER BY date DESC limit 1

now, should be OK
PM

[toma42]

Best to do the formatting in php as
$db->query("select unix_timestamp(datecolumn) as unixtime from table");

echo date("d m Y", $db->f('unixtime'));