Re: 'NOW' in UTC with no timezone - Mailing list pgsql-general

From Tom Lane
Subject Re: 'NOW' in UTC with no timezone
Date
Msg-id 2223.1097592189@sss.pgh.pa.us
Whole thread Raw
In response to Re: 'NOW' in UTC with no timezone  (Greg Stark <gsstark@mit.edu>)
Responses Re: 'NOW' in UTC with no timezone  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Greg Stark <gsstark@mit.edu> writes:
> I guess my confusion comes from the way postgres interprets unadorned time
> stamps as being in local time. And then always displays timestamps converted
> to local time. I thought it was remembering the time zone specified in the
> original input. In fact it's not doing that.

Indeed not.  (I think that the SQL spec contemplates that TIMESTAMP WITH
TIME ZONE *should* work that way, but that's not what we've done.)

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Confused with LABEL and LOOP
Next
From: Jerry LeVan
Date:
Subject: Message-ID as unique key?