Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group