Re: [sqlite] Time Zone Conversions

2015-01-07 Thread Keith Medcalf
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

2015-01-07 Thread Richard Hipp
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

2015-01-07 Thread Simon Slavin
> 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

2015-01-07 Thread MikeSnow
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

2015-01-07 Thread Igor Tandetnik
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

2015-01-07 Thread Simon Slavin
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

[sqlite] Time Zone Conversions

2015-01-07 Thread MikeSnow
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 2:00:00, EST, I would like to update UTC Datetime with logic