Re: Re: Problem with Dates

"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