Re: TimestampTZ

Поиск
Список
Период
Сортировка
От Paul Lambert
Тема Re: TimestampTZ
Дата
Msg-id 46BFF236.6010407@autoledgers.com.au
обсуждение исходный текст
Ответ на Re: TimestampTZ  (Paul Lambert <paul.lambert@autoledgers.com.au>)
Список pgsql-general
Paul Lambert wrote:
> Refer to this paragraph: (8.5.1.2)
>
> For timestamp with time zone, the internally stored value is always in
> UTC (Universal Coordinated Time, traditionally known as Greenwich Mean
> Time, GMT). An input value that has an explicit time zone specified is
> converted to UTC using the appropriate offset for that time zone. If no
> time zone is stated in the input string, then it is assumed to be in the
> time zone indicated by the system's timezone parameter, and is converted
> to UTC using the offset for the timezone zone.
>
>

Chapter 8.5.1.3 that was actaully, my apologies.

--
Paul Lambert
Database Administrator
AutoLedgers


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

Предыдущее
От: Paul Lambert
Дата:
Сообщение: Re: TimestampTZ
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: Persistent connections in PHP