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

[sqlite] Time Zone Conversions

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

RE: [sqlite] Time zone conversion

EMAIL PROTECTED] > Sent: Wednesday, December 20, 2006 10:30 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Time zone conversion > > Hi, > I would like to implement a time zone independent function. So I get the > time zone information from user, and plans to convert the

RE: [sqlite] Time zone conversion

To: sqlite-users@sqlite.org Subject: [sqlite] Time zone conversion Hi, I would like to implement a time zone independent function. So I get the time zone information from user, and plans to convert the datetime to the time zone specified. To make it clear I give an example here StartTime

[sqlite] Time zone conversion

Hi, I would like to implement a time zone independent function. So I get the time zone information from user, and plans to convert the datetime to the time zone specified. To make it clear I give an example here StartTime is stored as an integer in the database select

Re: AW: [sqlite] time zone?

1. Juli 2005 15:47 > An: sqlite-users@sqlite.org > Betreff: [sqlite] time zone? > > sqlite> select time('now'); > 13:45:20 > > $ date > Fri Jul 1 08:45:37 CDT 2005 > > anyone know what's wrong? > > thanks, > Stephen

AW: [sqlite] time zone?

Try select time('now', 'localtime'); Michael -Ursprüngliche Nachricht- Von: Stephen Leaf [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 1. Juli 2005 15:47 An: sqlite-users@sqlite.org Betreff: [sqlite] time zone? sqlite> select time('now'); 13:45:20 $ date Fri Jul 1 08:45:37 CDT 2

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('

[sqlite] time zone?

sqlite> select time('now'); 13:45:20 $ date Fri Jul 1 08:45:37 CDT 2005 anyone know what's wrong? thanks, Stephen