Re: Converting timestamp to timestamptz without rewriting tables

Поиск
Список
Период
Сортировка
От Tom Dunstan
Тема Re: Converting timestamp to timestamptz without rewriting tables
Дата
Msg-id CAPPfruztD8m1J_Ln3cvfxaUebKmdsYJpqXH9BeBdEGTC+8Ro-g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Converting timestamp to timestamptz without rewriting tables  (Thomas Kellerer <spam_eater@gmx.net>)
Ответы Re: Converting timestamp to timestamptz without rewriting tables  (Corey Taylor <corey.taylor.fl@gmail.com>)
Список pgsql-general
Дерево обсуждения


On 18 December 2017 at 18:43, Thomas Kellerer <spam_eater@gmx.net> wrote:
> All of the timestamps in our system represent an instant in time, not
> a clock date/time, so timestamp with time zone is more appropriate.
> All of the data that is currently on disk in timestamp columns was
> inserted in a db session in UTC, and represents that timestamp in
> UTC.


Are you aware of the fact that "timestamp with time zone" does NOT actually store the time zone?

Yes.
 
A timestamptz stores everything as UTC and the value is converted to the session time zone upon retrieval.

Which is exactly what we want.

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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Converting timestamp to timestamptz without rewriting tables
Следующее
От: Corey Taylor
Дата:
Сообщение: Re: Converting timestamp to timestamptz without rewriting tables