Understanding TIMESTAMP WITH TIME ZONE

Поиск
Список
Период
Сортировка
От Robert James
Тема Understanding TIMESTAMP WITH TIME ZONE
Дата
Msg-id CAGYyBghofo1S=cT3WzGsw5V1yx4_yYPZLZ8Wn9H=Uxb-WLMbwQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Understanding TIMESTAMP WITH TIME ZONE  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: Understanding TIMESTAMP WITH TIME ZONE  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-general
I'd like to better understand TIMESTAMP WITH TIME ZONE.

My understanding is that, contrary to what the name sounds like, the
time zone is never stored.  It simply stores a UTC timestamp,
identical to what TIMESTAMP WITHOUT TIME ZONE stores.

And then the only difference is that WITH TIME ZONE will allow you to
specify an offset in a literal value when INSERTing or UPDATEing ?
That sounds to me like a conversion or function - why is that a
different data type?


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

Предыдущее
От: Robert James
Дата:
Сообщение: Temp table's effect on performance
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Temp table's effect on performance