"Glen and Rosanne Eustace" <agree@godzone.net.nz> writes:
> If some one else is running 7.1 already and can just change their
> timezone to New Zealand DT and report the results it would be great.
Well, with TZ set to NZST-12NZDT I get
regression=# select '31/12/2000'::date::timestamp; ?column?
------------------------2000-12-31 00:00:00+13
(1 row)
regression=# select '31/12/2000'::date + '365 days'::timespan; ?column?
------------------------2001-12-31 00:00:00+13
(1 row)
This looks promising but I wouldn't call it conclusive, particularly
since you're probably using a different OS than I am (I'm on HPUX
10.20). It would be good to bang on it some more with NZ daylight
times --- as Christopher says, GMT+13 is a tad unusual.
regards, tom lane
