RE: [sqlite] Time formatting

2006-12-04 Thread Karthick V - TLS , Chennai
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

2006-11-28 Thread Dennis Cote
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