Re: [sqlite] Difference between localtime and utc is 8 hours, but should be 4

As Stephen observed when replying to your query, time math is fraught with problems. So I think it will be nothing to do with SQLite per se. I'm guessing it will be in the time offset specification you have entered somewhere, for your environment. You are in what is termed time zone utc -4.

Re: [sqlite] Difference between localtime and utc is 8 hours, but should be 4

That makes sense. Thank you very much. RobR -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Stephen Chrzanowski Sent: Friday, April 21, 2017 4:29 PM To: SQLite mailing list Subject: Re: [sqlite] Difference between localtime and

Re: [sqlite] Difference between localtime and utc is 8 hours, but should be 4

Let me clarify; What you store in the database is just a number. There is no indication to what timezone that references. So when you convert UTC to UTC, you're taking a time already set for UTC and converting it to another 4 hours earlier (Or later? -- i hate time math). When I say "UTC to

Re: [sqlite] Difference between localtime and utc is 8 hours, but should be 4

Because you're converting your UTC time to UTC. On Fri, Apr 21, 2017 at 4:03 PM, Rob Richardson wrote: > Hello! > > I'm in the Eastern US time zone, in daylight savings time. I am four > hours earlier than UTC time. I have a column that stores UTC times as > Julian