RE: [sqlite] Time formatting

end from twotimes Works fine for any time zone. With Regards Karthick V "The secret of being miserable is to have leisure to bother about whether you are happy or not. The cure for it is occupation." George Bernard Shaw (1856-1950) -Original Message- From: Dennis Cote [ma

Re: [sqlite] Time formatting

Karthick V - TLS , Chennai wrote: Hi everyone, I am trying to generate a time information with the time zone offset information in the UTC format -MM-DDTHH:MM:SS.mmm+HH:MM Try this: select strftime('%Y-%m-%dT%H:%M:%f', 'now', 'localtime') || case when strftime

[sqlite] Time formatting

Hi everyone, I am trying to generate a time information with the time zone offset information in the UTC format -MM-DDTHH:MM:SS.mmm+HH:MM with the last HH and MM referring to the offset of the timezone hours and minutes from the GMT. My table is created using the following queries CREAT