mysql 12 hr to 24 hr time conversion

Question

How can we convert the time in AM/PM to 24-hrs format. For eg. (1:30 PM) should be converted to (13:30).

Answer 1

Dates / Times are stored in mysql the same way regardless of how they are formatted.

I believe what you want to do is retrieve the date in a specified format.

The DATE_FORMAT() will do this for you.

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format

%r and %T are 12 hour and 24 hour time formats respectively.