al Message-
>From: sqlite-users-boun...@sqlite.org [mailto:sqlite-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 ge
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 2:00:00, EST,
You have a
> 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
>
> datetime("Column_Time", 'utc')?
SELECT dateti
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:
http://sqlite.1065341.n5.nabble.com
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'
end)
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 Datetime with logic based off "T
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
7 matches
Mail list logo