Re: Re: Problem with Dates - Mailing list pgsql-sql

From Brett W. McCoy
Subject Re: Re: Problem with Dates
Date
Msg-id Pine.LNX.4.30.0101250708480.24393-100000@chapelperilous.net
Whole thread Raw
In response to Re: Re: Problem with Dates  ("Glen and Rosanne Eustace" <agree@godzone.net.nz>)
List 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.



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: Problem with Dates
Next
From: "Glen and Rosanne Eustace"
Date:
Subject: Re: Re: Problem with Dates