Convert time from 12 hour to 24 hour in sql lite

Question

User-2028591720 posted

Hello All,

This is above query,

CREATE TABLE rawdata (timestamp text,dttime text);
INSERT INTO rawdata VALUES('4/14/2012 3:50:09 PM',"06:30 PM");
INSERT INTO rawdata VALUES('4/14/2012 3:51:09 pm',"07:30 PM");

I want to convert the time from 12 hour to 24 hour in the sql lite

Regards, Prasad

Answer 1

User-2082239438 posted

Make Timestamp column data type to DATETIME, MSSQL database will automatically convert 12 hour format to 24 hour.

FYI.

DECLARE @DATE DATETIME='4/14/2012 3:50:09 PM'

SELECT @DATE AS DATE

---OUTPUT
--DATE
--2012-04-14 15:50:09.000

Answer 2

User-821857111 posted

The accepted solution in this StackOverflow thread should help: https://stackoverflow.com/questions/20655003/converting-12-hour-to-24-hour-time-format-in-sqlite