Tom Lane wrote:
>
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > In the CET zone (where you probably live) daylight savings time ends in
> > October, so it is true that
>
> > 1999-10-01 00:00:00 + (24h * 31 days) = 1999-10-31 23:00:00
>
> > Of course a month is not defined as "24h * 3
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> In the CET zone (where you probably live) daylight savings time ends in
> October, so it is true that
> 1999-10-01 00:00:00 + (24h * 31 days) = 1999-10-31 23:00:00
> Of course a month is not defined as "24h * 30/31 days" but instead as the
> t
Guillaume Perréal writes:
> Try computing (replace with some differents years):
> '-10-01'::datetime + '1 month'::interval
> Depending on the year, you can get '-11-01' as expected or '-10-31'
> which is bug.
In the CET zone (where you probably live) daylight savings time