Re: [SQL] Re: Problem with Dates

[Brett W. McCoy]

On Sat, 27 Jan 2001, Glen and Rosanne Eustace wrote:

> 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.

Here ya are:

cp=> set time zone 'NZ';

SET VARIABLE
cp=> select '12/31/2000'::date + '1 year'::interval;
        ?column?
------------------------
 2001-12-31 00:00:00+13
(1 row)

cp=>

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
It's a good thing we don't get all the government we pay for.