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.