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.