Horton

A date bug: number of day of October

Guillaume Perréal <perreal@lyon.cemagref.fr>

View thread
From: Guillaume Perréal <perreal@lyon.cemagref.fr>
To: pgsql-bugs@postgresql.org
Date: 2000-04-13T07:29:02Z
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