locked
Convert time from 12 hour to 24 hour in sql lite RRS feed

  • 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

    Thursday, June 11, 2020 10:58 AM

Answers

All replies