Re: Reading timestamp values from Datums gives garbage values

Поиск
Список
Период
Сортировка
От Sushrut Shivaswamy
Тема Re: Reading timestamp values from Datums gives garbage values
Дата
Msg-id CAH5mb9-RLuE+wGDqRx-QsLJ8-15Op=Nn-f7dRRTnEHtBmwvX4A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Reading timestamp values from Datums gives garbage values  (Aleksander Alekseev <aleksander@timescale.com>)
Список pgsql-hackers
Дерево обсуждения
Thank you everyone for your responses.

I was a bit thrown off by the timestamp value the first time I printed it by how small it was.
The revelation that postgres TimestampTz uses an epoch (time zero) of 2000-01-01 helped clarify
that value would indeed be smaller than regular UNIX epoch.

In my case I was trying to convert a diff of two timestamps into epoch seconds which explains why the value
was just 1.5hr. My issue is now resolved.

Thanks again
 - Sushrut

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Avoid orphaned objects dependencies, take 3
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: ALTER TABLE SET ACCESS METHOD on partitioned tables