How MySQL date format DD MM YYYY select query

Question

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

How to do that?

Answer 1

Hello @kartik,

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.

Hope it helps!!
Thank You!!