Re: [SQL] Re: Problem with Dates

[Tom Lane]

"Glen and Rosanne Eustace" <[EMAIL PROTECTED]> 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