Re: Problem with Dates

template1=# select '31/12/2000'::date; ?column?
------------2000-12-31
(1 row)

template1=# select '31/12/2000'::date + '365 days'::timespan;       ?column?
------------------------2002-01-01 00:00:00+13    <<<<<<<<<<< Wrong
(1 row)

template1=# select '31/12/2000'::date + '364 days'::timespan;       ?column?
------------------------2001-12-31 00:00:00+13
(1 row)

template1=# select '31/12/2000'::date + '363 days'::timespan;       ?column?
------------------------2001-12-30 00:00:00+13
(1 row)

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

I have tried looking here but it is pretty hard to know what to look
for.

Glen.