Re: timestamps and dates

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: timestamps and dates
Дата
Msg-id 604.1051571052@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: timestamps and dates  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Список pgsql-general
"Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> localtime is linked to /usr/share/zoneinfo/right/GB
> where as may be setting TZ or explicitly setting the GUC is picking up
> /usr/share/zoneinfo/posix/GB or /usr/share/zoneinfo/GB.

IIRC, the "posix" ones are non-leap-second-aware.  Systems which have a
"right" directory have leap-second-aware timezone files in that
subdirectory.

As for how "right" it is to track leap seconds, I note that the powers
that control such things are seriously considering abandoning leap
seconds.  Having unpredictable future differences between UTC and TAI
sucks.

            regards, tom lane


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

Предыдущее
От: Dennis Gearon
Дата:
Сообщение: Re: Setting a field to default if blank value
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: adding times togeather