[SQL] Re: Problem with Dates

[Glen and Rosanne Eustace]

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.