Re: date with month and year

Поиск
Список
Период
Сортировка
От Brian Dunavant
Тема Re: date with month and year
Дата
Msg-id CAJTy2e=EzT7Ct7JSBN5V_7SZCfjT2GdEPsFsaev=22_LWXA0ZA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: date with month and year  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-general
On Thu, May 21, 2015 at 5:27 PM, Thomas Kellerer <spam_eater@gmx.net> wrote:
> Postgres does not store the time zone. When storing a timestamp with time
> zone, it
> is normalized to UTC based on the timezone of the client. When you retrieve
> it,
> it is adjusted to the time zone of the client.
>

Sorry, I misspoke.  Thank you for correcting it.  It is storing it as
UTC time zone.  The rest of my post still applies.  You will get the
wrong wall-clock time for the future date because it is stored as UTC
and the conversion rules will have changed giving you a different time
when you convert it back to the local time zone.


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

Предыдущее
От: Paul Jungwirth
Дата:
Сообщение: Re: date with month and year
Следующее
От: Andy Chambers
Дата:
Сообщение: Re: Unit tests and foreign key constraints