Re: Thoroughly confused about time zones

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Rob Richardson <Rob(dot)Richardson(at)rad-con(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Thoroughly confused about time zones
Date: 2011-02-28 15:18:36
Message-ID: 5DA0FC56-AE71-483F-BCEF-7AA97510A677@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 help me.

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

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2011-02-28 15:21:47 Re: Permission denied when inserting
Previous Message Rob Richardson 2011-02-28 15:18:35 Re: Thoroughly confused about time zones