| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
| Cc: | Antti Haapala <antti(dot)haapala(at)iki(dot)fi>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: timestamps and dates |
| Date: | 2003-04-28 23:04:12 |
| Message-ID: | 604.1051571052@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Nigel J. Andrews" <nandrews(at)investsystems(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Gearon | 2003-04-28 23:05:14 | Re: Setting a field to default if blank value |
| Previous Message | Dennis Gearon | 2003-04-28 22:59:48 | Re: Fwd: Re: Selecting the most recent date |