If other words, when I do this
Code: Select all
Select * FROM table ORDER BY course_date2005-12-20
2005-12-30
2006-01-15
2006-02-11
When I do this however, my sort gets screwed up:
Code: Select all
SELECT date_format(record_date,'%M %d, %Y') as course_date FROM table order by course_dateDecember 30, 2005
February 11, 2006
January 15, 2006
(February is listed before January because it's ordered alphabetically).
How do I correct that so it's sorting chronologically but giving me the more friendly date formatting? Thanks!!
-Chris