按升序排序日期

Question

我有一个查询，其中日期的格式是“YYYY-MM-DD”，我想对其进行排序。因此，我使用了

SELECT DATE_FORMAT(AudiEvent.EventDate,'%d-%m-20%y') as Event_Date
from AudiEvent
ORDER BY Event_Date

实际输出 -

Event_Date
06-12-2013
09-11-2013
18-12-2013
26-11-2013

预期输出 -

Event_Date
09-11-2013
26-11-2013
06-12-2013
18-12-2013

- MrCoder

Answer 1

请使用 AudiEvent.EventDate 日期字段进行排序。

  SELECT DATE_FORMAT(AudiEvent.EventDate,'%d-%m-20%y') as Event_Date
    from AudiEvent
    ORDER BY AudiEvent.EventDate

- Girish

Answer 2

ORDER BY DATE_FORMAT(AudiEvent.EventDate,'%d-%m-20%y') 

- Sully

Answer 3

在EventDate之前添加AudiEvent

    SELECT DATE_FORMAT(AudiEvent.EventDate,'%d-%m-20%y') as Event_Date
    from AudiEvent
    ORDER BY AudiEvent.EventDate

- Neel

---

这是一个错误，谢谢 @Girish - Neel

Answer 4

试试这个，

select  DATE_FORMAT(AudiEvent.EventDate,'%d-%m-20%y') as Event_Date
from AudiEvent
order by  DATE_FORMAT(AudiEvent.EventDate,'%d-%m-20%y') 

- Wit Wikky

Answer 5

SELECT DATE_FORMAT(AudiEvent.EventDate,'%d-%m-20%y') as Event_Date
from AudiEvent
ORDER BY AudiEvent.EventDate ASC

- Rizvi