| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Gary Bernhardt <gary(dot)bernhardt(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:32:51 |
| Message-ID: | CAKFQuwaUeC-VqtWDu_ASVGaWh1ktppF1HqN_5Nb16DRe6-AXOQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Mon, Jun 25, 2018 at 5:25 PM, Gary Bernhardt <gary(dot)bernhardt(at)gmail(dot)com>
wrote:
> 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.
>
Care to be more specific? You didn't really provide an example that gives
others insight into why you would use "AT TIME ZONE" twice in the same
expression.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gary Bernhardt | 2018-06-26 00:40:27 | Re: Converting to UTC multiple times converts back to local time zone |
| Previous Message | Gary Bernhardt | 2018-06-26 00:25:35 | Re: Converting to UTC multiple times converts back to local time zone |