Re: [sqlite] Time Zone Conversions

te-users- >boun...@sqlite.org] On Behalf Of MikeSnow >Sent: Wednesday, 7 January, 2015 07:00 >To: sqlite-users@sqlite.org >Subject: Re: [sqlite] Time Zone Conversions > >I am kind of new at this. so if I get you, I should concat the 3 >columns >to get one in the suggest

Re: [sqlite] Time Zone Conversions

On 1/6/15, MikeSnow wrote: > As I look through the posts, i dont see what I am looking for. > > I am trying to create a CASE statement that converts time zones to UTC for > db storage. > For example, I have 3 columns, ReceiveDate, Timezone, UTC Datetime. > 04/11/2014

Re: [sqlite] Time Zone Conversions

> On 7 Jan 2015, at 2:00pm, MikeSnow wrote: > > I am kind of new at this. so if I get you, I should concat the 3 columns > to get one in the suggested format. But then how do you convert? > > "Column_Time" > 2013-10-07 04:23:19.120-04:00 > >

Re: [sqlite] Time Zone Conversions

I am kind of new at this. so if I get you, I should concat the 3 columns to get one in the suggested format. But then how do you convert? "Column_Time" 2013-10-07 04:23:19.120-04:00 datetime("Column_Time", 'utc')? -- View this message in context:

Re: [sqlite] Time Zone Conversions

On 1/6/2015 1:13 PM, MikeSnow wrote: Something like if Update t1. SET "UTC Datetime"=if "TimeZone"='EST', then "ReceiveDate"+5 update t1 SET "UTC Datetime" = datetime(ReceiveDate, (case TimeZone when 'EST' then '+5' when 'PST' then '+8' -- add more clauses to taste else '+0'

Re: [sqlite] Time Zone Conversions

On 6 Jan 2015, at 6:13pm, MikeSnow wrote: > I am trying to create a CASE statement that converts time zones to UTC for > db storage. > For example, I have 3 columns, ReceiveDate, Timezone, UTC Datetime. > 04/11/2014 2:00:00, EST, > > I would like to update UTC

RE: [sqlite] Time zone conversion

Thanks Karthick. My code too works fine... (I made a small typo mistake in query, which executed silently) But I guess your method is the right one. Regards, Lloyd On Wed, 2006-12-20 at 16:54 +0530, Karthick V - TLS , Chennai wrote: > Let the time zone given by user > +0530 > > Therefore

RE: [sqlite] Time zone conversion

Let the time zone given by user +0530 Therefore its 330 minutes / 13200 seconds select datetime( StartTime,'unixepoch','+13200.0 seconds') from mytable --- gives you the local time Select datetime( StartTime,'unixepoch')gives u universal time Where StartTime is an integer(unixtimestamp

RE: [sqlite] time zone?

Hi, I am not sure but one is in GMT and other maybe in your local time zone. Regards Sudhir -Original Message- From: Stephen Leaf [mailto:[EMAIL PROTECTED] Sent: Friday, July 01, 2005 9:47 AM To: sqlite-users@sqlite.org Subject: [sqlite] time zone? sqlite> select time('now');