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 Quote Link to comment 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 Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.