I am facing problem with sorting according to AM / PM.
Here is my table data
login_time
1:30 PM
2:00 AM
8:00 AM
9:30 PM
10:00 PM
11:10 AM
I want result as:
login_time
2:00 AM
8:00 AM
11:10 AM
1:30 PM
9:30 PM
10:00 PM
How can I do this?
You could use STR_TO_DATE function, and you could also extract only the time part with TIME() if you wish:
SELECT
login_time
FROM
tablename
ORDER BY
STR_TO_DATE(login_time, '%l:%i %p')
Please see fiddle here.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With