A date bug: number of day of October

From: Guillaume Perréal <perreal(at)lyon(dot)cemagref(dot)fr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: A date bug: number of day of October
Date: 2000-04-13 07:29:02
Message-ID: 38F5773E.DA99368B@lyon.cemagref.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi all,

I think there is a bug in the PostgreSQL date system:

Try computing (replace XXXX with some differents years):
'XXXX-10-01'::datetime + '1 month'::interval
Depending on the year, you can get 'XXXX-11-01' as expected or 'XXXX-10-31'
which is bug.

Guillaume Perréal - Stagiaire MIAG
Cemagref (URH), Lyon, France
Tél: (+33) 4.72.20.87.64

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Fabienne Leclere 2000-04-13 08:28:33 ECPGdo
Previous Message Peter Eisentraut 2000-04-13 02:04:47 Re: Re: [SQL] Foreign keys breaks tables permissions