On Thu, Apr 13, 2000 at 09:24:36AM +0200, Guillaume Perréal wrote:
>
> Thanks, I rewrote my function to solve my problem.
>
> In fact, the problem is that ('2000-10-01'::datetime + '1 month'::interval)
> gives '2000-10-31' instead of '2000-11-01'.
> I think it's a bug, isn't it?
It's our old friend daylight savings changeover:
rfb=# select ('2000-10-01'::datetime + '1 month'::interval);
?column?
------------------------
2000-10-31 23:00:00+00
(1 row)
^^
1 hour less because going from summer -> winter (For me BST->GMT)
Cheers,
Patrick