Re: [BUGS] A date bug: number of day of October

2000-04-17 Thread Guillaume Perréal
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

Re: [BUGS] A date bug: number of day of October

2000-04-14 Thread Tom Lane
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

Re: [BUGS] A date bug: number of day of October

2000-04-14 Thread Peter Eisentraut
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