Postgres Pro
Downloads
Home   >   mailing lists

Re: Thoroughly confused about time zones - Mailing list pgsql-general

From Scott Ribe
Subject Re: Thoroughly confused about time zones
Date
Msg-id 5DA0FC56-AE71-483F-BCEF-7AA97510A677@elevated-dev.com
Whole thread Raw
In response to Thoroughly confused about time zones  ("Rob Richardson" <Rob.Richardson@rad-con.com>)
List pgsql-general
Tree view 
On Feb 28, 2011, at 8:06 AM, Rob Richardson wrote:

> But if PostgreSQL doesn’t store time zones internally, then that difference is going to be 24 hours, which doesn’t
helpme. 

No, postgres stores timestamptz as UTC, so that calculation will work exactly like you want.

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice

pgsql-general by date:

Previous
From: Borek Lupomesky
Date:
Subject: Permission denied when inserting
Next
From: "Rob Richardson"
Date:
Subject: Re: Thoroughly confused about time zones