Re: timestamps and dates - Mailing list pgsql-general

From Tom Lane
Subject Re: timestamps and dates
Date
Msg-id 604.1051571052@sss.pgh.pa.us
Whole thread Raw
In response to Re: timestamps and dates  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List 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 by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: Setting a field to default if blank value
Next
From: Steve Crawford
Date:
Subject: Re: adding times togeather