MySQL date format DD/MM/YYYY select query?

Question

I am really confused about how to order by date formats.

For the format YYYY-MM-DD you will do this: ...ORDER BY date DESC...

How will you order by DD/MM/YYYY?

This isn't working:

SELECT * FROM $table ORDER BY DATE_FORMAT(Date, '%Y%m%d') DESC LIMIT 14

Answer 1

You could 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 the strings.

If you want to learn more about SQL, Check out this SQL Certification by Intellipaat.