I have a table in mysql and one of the fields contains dates formatted ‘DD-MM-YYYY’.
I’ve been trying to order the results by the date field using:
SELECT * FROM table ORDER BY DATE_FORMAT(date, ‘%d-%m-%Y’) ASC
But this doesn’t order the results correctly. I’ve googled it a bit and I think I’ve got this correct.
Can anyone help, and let me know the correct way to do this.
Thanks
