Re: Converting to UTC multiple times converts back to local time zone

From: Gary Bernhardt <gary(dot)bernhardt(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Converting to UTC multiple times converts back to local time zone
Date: 2018-06-26 00:25:35
Message-ID: 1529972735.44579.1420252720.11BFA61D@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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 other features 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 consistent with other features.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2018-06-26 00:32:51 Re: Converting to UTC multiple times converts back to local time zone
Previous Message David G. Johnston 2018-06-26 00:20:28 Re: Converting to UTC multiple times converts back to local time zone