Postgres Pro
Downloads
Home   >   mailing lists

Re: Converting to UTC multiple times converts back to local time zone - Mailing list pgsql-bugs

From Gary Bernhardt
Subject Re: Converting to UTC multiple times converts back to local time zone
Date
Msg-id 1529972735.44579.1420252720.11BFA61D@webmail.messagingengine.com
Whole thread Raw
In response to Re: Converting to UTC multiple times converts back to local time zone  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Converting to UTC multiple times converts back to local time zone
List pgsql-bugs
Tree view 
On Mon, Jun 25, 2018, at 5:20 PM, David G. Johnston wrote:
> I'll agree that this was a surprising finding for me too, but in the overall scheme of how PostgreSQL works, and
otherfeatures it provides (e.g., TimeZone GUC and to_char()) it fits.
 

Thanks, David. I find this behavior quite off-putting, but I'm happy to take your word that it's intended and
consistentwith other features.

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Converting to UTC multiple times converts back to local time zone
Next
From: "David G. Johnston"
Date:
Subject: Re: Converting to UTC multiple times converts back to local time zone