ORDER BY日期仅使用天数和月数mysql进行排序

Question

Here's my sql query :

SELECT uid, title, startTime, endTime, cover FROM event ORDER BY startTime DESC 

But this will bring me elements in this order :

 12/30/2013      00:00
 12/25/2013      00:00
 01/10/2014      00:00

Looks like it's sorting only using days and months.

Do you have any idea about this ?

Thank you.

Answer 1

In case you really have stored them as string, STR_TO_DATE() should be able to solve this.

SELECT uid, title, startTime, endTime, cover 
FROM event 
ORDER BY STR_TO_DATE( startTime, '%m/%d/%Y' ) DESC