Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1. 17-03-2016 01:26 PM
- 2. 17-03-2016 01:31 PM
- 3. 17-03-2016 01:34 PM
- 4. 17-03-2016 01:44 PM
- 5. 17-03-2016 10:33 AM
- 1. 17-03-2016 10:33 AM
- 2. 17-03-2016 01:26 PM
- 3. 17-03-2016 01:31 PM
- 4. 17-03-2016 01:34 PM
- 5. 17-03-2016 01:44 PM
- SELECT *
- FROM table_name
- ORDER BY STR_TO_DATE(new_meeting_time, '%d-%m-%Y %h:%i:%s') ASC
- SELECT * FROM table_name ORDER BY STR_TO_DATE(new_meeting_time,'%d-%m-%Y %h:%i %p');
- mysql> select STR_TO_DATE('17-03-2016 01:26 PM','%d-%m-%Y %h:%i %p');
- +--------------------------------------------------------+
- | STR_TO_DATE('17-03-2016 01:26 PM','%d-%m-%Y %h:%i %p') |
- +--------------------------------------------------------+
- | 2016-03-17 13:26:00 |
- +--------------------------------------------------------+
- 1 row in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment