Re: Timestamp with and without timezone conversion confusion.

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Timestamp with and without timezone conversion confusion.
Date: 2013-10-02 17:40:36
Message-ID: 524C5A94.3050307@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/02/2013 04:19 AM, Karsten Hilbert wrote:
> On Wed, Oct 02, 2013 at 09:49:38PM +1300, Tim Uckun wrote:
>
>>> The reason for that is that in PostgreSQL there is no time zone
>> information stored along with a "timestamp with time zone",
>> it is stored in UTC.
> A better name might perhaps been "timezone aware timestamp".
>
> Karsten

The trouble is that it isn't timezone aware.

When I have to explain this I tend to tell people to mentally change
"timestamp with time zone" to "point-in-time". That "point-in-time" data
can be represented in many different formats and "localized" to
different zones but they are all the identical point-in-time.

Cheers,
Steve

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Gierth 2013-10-02 17:45:24 Re: [HACKERS] Who is pgFoundery administrator?
Previous Message Kevin Grittner 2013-10-02 17:14:18 Re: partitioning for speed, but query planner ignores