Re: 'NOW' in UTC with no timezone

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