MySQL date format DD MM YYYY select query

Question

I m a bit confused on how to order by date formats    For the format YYYY-MM-DD you would do this     ORDER BY date DESC     How would you order by DD MM YYYY   This isn t working   SELECT   FROM  table ORDER BY DATE FORMAT Date    Y m d   DESC LIMIT 14

User · Accepted Answer

You can use STR TO DATE   to convert your strings to MySQL date values and ORDER BY the result   ORDER BY STR TO DATE datestring    d  m  Y     However  you would be wise to convert the column to the DATE data type instead of using strings

User · Answer

If the hour is important  I used str to date date    d  m  Y  T     the  T shows the hour in the format hh mm ss

User · Answer

Guessing you probably just want to format the output date  then this is what you are after  SELECT    DATE FORMAT date   d  m  Y   AS niceDate  FROM table  ORDER BY date DESC  LIMIT 0 14   Or do you actually want to sort by Day before Month before Year

User · Answer

SELECT DATE FORMAT somedate    d  m  Y   AS formatted date            ORDER BY formatted date DESC

User · Answer

ORDER BY a date type does not depend on the date format  the date format is only for showing  in the database  they are same data

User · Answer

for my case this worked   str to date date    e  m  Y

User · Answer

Use   SELECT DATE FORMAT NAME COLUMN    d  l  Y   AS  NAME  SELECT DATE FORMAT NAME COLUMN    d  l  Y  H  i  s   AS  NAME    Reference  https   dev mysql com doc refman 5 7 en date-and-time-functions html

User · Answer

SELECT DATE FORMAT COLUMN NAME    d  m  Y  h  i  p      OR  SELECT DATE FORMAT  2019-05-10 19 30 10     d  m  Y  h  i  p         OUTPUT is 10 05 2019 07 30 PM

[mysql] MySQL date format DD/MM/YYYY select query?

Examples related to mysql