gurechan Posted July 22, 2008 Share Posted July 22, 2008 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 Link to comment https://forums.phpfreaks.com/topic/116015-mysql-date_format/ Share on other sites More sharing options...
Zwiter Posted July 22, 2008 Share Posted July 22, 2008 This is not working? I'm surprised ??? SELECT * FROM table ORDER BY date ASC Link to comment https://forums.phpfreaks.com/topic/116015-mysql-date_format/#findComment-596562 Share on other sites More sharing options...
fenway Posted July 23, 2008 Share Posted July 23, 2008 You'll need to use STR_TO_DATE if they're not really dates. Link to comment https://forums.phpfreaks.com/topic/116015-mysql-date_format/#findComment-598044 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.