Horton

Re: Re: Problem with Dates

Brett W. McCoy <bmccoy@chapelperilous.net>

View thread View on postgr.es
From: "Brett W. McCoy" <bmccoy@chapelperilous.net>
To: Glen and Rosanne Eustace <agree@godzone.net.nz>
Cc: Christopher Sawtell <csawtell@xtra.co.nz>, Tom Lane <tgl@sss.pgh.pa.us>, <pgsql-sql@postgresql.org>
Date: 2001-01-25T12:11:06Z
Lists: pgsql-sql 
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.