Why doesn't MySQL sort by date correctly?

Question

MySQL

There is a table with orders.

And I need to get all orders from it by date in reverse order. I wrote this query:

SELECT id, DATE_FORMAT(date, "%d.%m.%Y") as date, status
FROM orders
ORDER BY date DESC

But for some reason it displays orders in discord, without any sorting.

Why doesn't sorting work?

Answer 1

Because after DATE_FORMAT you are not sorting dates, just strings.
Try like this:ORDER BY orders.date DESC