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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Converting to UTC multiple times converts back to local time zone
Дата
Msg-id CAKFQuwaUeC-VqtWDu_ASVGaWh1ktppF1HqN_5Nb16DRe6-AXOQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Converting to UTC multiple times converts back to local time zone  (Gary Bernhardt <gary.bernhardt@gmail.com>)
Ответы Re: Converting to UTC multiple times converts back to local time zone  (Gary Bernhardt <gary.bernhardt@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
On Mon, Jun 25, 2018 at 5:25 PM, Gary Bernhardt <gary.bernhardt@gmail.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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Gary Bernhardt
Дата:
Сообщение: Re: Converting to UTC multiple times converts back to local time zone
Следующее
От: Gary Bernhardt
Дата:
Сообщение: Re: Converting to UTC multiple times converts back to local time zone