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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
