Re: jsonpath: Inconsistency of timestamp_tz() Output

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: jsonpath: Inconsistency of timestamp_tz() Output
Дата
Msg-id 287C2A57-2AD9-4D0D-9452-EDE9CDA8A7E8@justatheory.com
обсуждение исходный текст
Ответ на Re: jsonpath: Inconsistency of timestamp_tz() Output  ("David E. Wheeler" <david@justatheory.com>)
Список pgsql-hackers
On Jul 10, 2024, at 10:54, David E. Wheeler <david@justatheory.com> wrote:

> So it should be -7, not -8. Not sure where to tell it to pay proper attention to daylight savings time.

Oh, and the time and date were wrong, too, because I blindly used the same conversion for dates as for timestamps.
Fixedin v2. 

PR: https://github.com/theory/postgres/pull/7
CF: https://commitfest.postgresql.org/49/5119/

Best,

David




Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Add a GUC check hook to ensure summarize_wal cannot be enabled when wal_level is minimal
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Is it possible to create a cursor with hold using extended query protocol