Hi, I have a column "statustime" in a table , which has values( like,10:24:10 PM,12:04:00 AM) with mixed of AM and PM . I want to display the other values by "statustime" in ASC . How to do?
AntonyRayan
15
Posting Whiz in Training
Recommended Answers
Jump to PostDate and time output formatting can easily be done with a format string in the query. Check the MySQL online documentation for your version for details: www.mysql.com
Jump to PostYou may have better luck with storing times in 24 hour format. Then it takes care of itself.
All 7 Replies
rubberman
1,355
Nearly a Posting Virtuoso
Featured Poster
diafol
AntonyRayan
15
Posting Whiz in Training
jkon
602
Posting Whiz in Training
Featured Poster
diafol
Lauren_2
0
Newbie Poster
cereal
1,524
Nearly a Senior Poster
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.