从数据库中检索日期[关闭]

Question

i got a release_date row in my database now i want too display the latest date on top

my query now:$sql = "SELECT * FROM games ORDER BY release_date ASC";

but this ORDER BY just get the first digits (day) of the date Now i get:

03-11-2014 12-11-2013 14-07-2011 16-03-2012

it needs to be:

03-11-2014 12-11-2013 16-03-2012 14-07-2011

Answer 1

Use STR_TO_DATE to turn your date string into a real date.

SELECT * FROM games 
ORDER BY STR_TO_DATE(release_date, '%d-%m-%Y') DESC

You can also use this function to refomat your date into the default format and then change the column data type to date.