Re: [GENERAL] recovery dump on database with different timezone

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [GENERAL] recovery dump on database with different timezone
Дата
Msg-id CAKFQuwYa8+-UJGfeK0t-8eUt-8HPwJjZt91k3gbWvp+87bWadA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] recovery dump on database with different timezone  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: [GENERAL] recovery dump on database with different timezone  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения
On Mon, Jan 23, 2017 at 6:08 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:

production=# show timezone;
 TimeZone
----------
 UTC
(1 row)

 production=# select ' 2011-01-01 00:00:03.925-06'::timestamptz  < '2011-01-01'::date;
 ?column?
----------
 f

​What Tom said - though I missed the part about "the timezone when the data was entered" - I was thinking it was only ​the timezone at the time of the dump that would impact things.

To your example - testing in UTC is going to always result in failure for Z values <= 0 since they will all result in a UTC date of 2011-01-01.  Choosing +06 would result in a passed test.

David J.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] recovery dump on database with different timezone
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] recovery dump on database with different timezone