Postgres Pro
Downloads
Home   >   mailing lists

A date bug: number of day of October - Mailing list pgsql-bugs

From Guillaume Perréal
Subject A date bug: number of day of October
Date
Msg-id 38F5773E.DA99368B@lyon.cemagref.fr
Whole thread Raw
Responses Re: A date bug: number of day of October  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Re: [SQL] Foreign keys breaks tables permissions
Next
From: Fabienne Leclere
Date:
Subject: ECPGdo