Re: Problem with Dates

On Thu, Jan 25, 2001 at 03:06:38PM +1300, Glen and Rosanne Eustace wrote:
> pressie# select '31/12/2000'::date + '1 year'::timespan;
> ?column?
> -----------------------------
> 01/01/2002 00:00:00.00 NZDT
> (1 row)

What are the outputs of
select '31/12/2000'::date;
select '31/12/2000'::date + '365 days'::timespan;

and 364, 363, etc.

Not sure if gets you anywhere. But data points.

There is an email archive on the postgresql.org website you could search if
you think it's been answered before.

mrc
--
Mike Castle Life is like a clock: You can work constantly
dalgoda(at)ix(dot)netcom(dot)com and be right all the time, or not work at all
www.netcom.com/~dalgoda/ and be right at least twice a day. -- mrc
We are all of us living in the shadow of Manhattan. -- Watchmen