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@ix.netcom.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