rocknbil - 5:57 pm on Sep 4, 2010 (gmt 0)

Ack you're right, but - you still have to quote the format string.

select date_format(THE_COLUMN_NAME, "%M-%d-%Y");

or

select date_format(`THE_COLUMN_NAME`, "%M-%d-%Y");