CODEWITHSUNDEEP
mysqlsql
MrCoder
MrCoder

Reputation: 103

Sorting the date in ascending order

I have a query in which date is in 'YYYY-MM-DD' format, and I am looking to sort this. So, I used 

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

Actual Output - 

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

Expected Output - 

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

Upvotes: 3

Views: 107

Answers (5)

Rizvi
Rizvi

Reputation: 283

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

Upvotes: 0

Wit Wikky
Wit Wikky

Reputation: 1542

Try this ,

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

Upvotes: 0

Neel
Neel

Reputation: 11721

You need to add AudiEvent before EventDate

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

Upvotes: 2

Sully
Sully

Reputation: 14943

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

Upvotes: 2

Girish
Girish

Reputation: 12117

Please use AudiEvent.EventDate date field in sorting

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

Upvotes: 3

Related Questions