Hi all,
This is Rajesh. I am using SQLITE db. Actually in my database i have one column.i want to convert my column value am/pm to 24hrs formate. Ex: Step 1: I have one column. Column name: Ts Column Have this value :2016-09-19 08:56:00 PM. My Query: strftime('%m/%d/%Y',trim(Ts,'AM/PM') ) as T. when i am running this query i get this output Output: 08:56:00. Step 2: i don't want output like 08:56:00.because end user don't know whether 08:56:00 Am or Pm. so i want like this : 20:56:00 (i want ony time in 24hrs formate) Step 3: its possible or Not.If possible how its possible. Step 4: is there any way to get only time from my column. Column name: Ts Column Have this value :2016-09-19 08:56:00 PM. Please send Reply. its priority issue. Thanks & Regards M.Rajesh _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users