suresh64633 Posted September 16, 2009 Share Posted September 16, 2009 Hi I have a table in which time is store as "1.00 PM" in varchar datatype. Now i want to sort records with this fields. As it is varchar it does not work properly. I need any function [AS strtotime() in php] by which i can convert this time to 24 hours format so i can sort it easily. Thanks!! Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted September 16, 2009 Share Posted September 16, 2009 http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_str-to-date Quote Link to comment Share on other sites More sharing options...
suresh64633 Posted September 16, 2009 Author Share Posted September 16, 2009 i try to use like this but not working SELECT STR_TO_DATE( '09:30:17 PM', '%h:%i:%s' ) ; result is "09:30:17" it should be 21:30:17 Thanks Quote Link to comment Share on other sites More sharing options...
artacus Posted September 16, 2009 Share Posted September 16, 2009 SELECT STR_TO_DATE( '09:30:17 PM', '%h:%i:%s %p' ) ; Missing the AM/PM indicator. Quote Link to comment Share on other sites More sharing options...
suresh64633 Posted September 17, 2009 Author Share Posted September 17, 2009 Thanks artacus 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.