leap day bug after 1901

From: José Soares <jose(at)sferacarta(dot)com>
To: hackers <pgsql-hackers(at)postgresql(dot)org>, general <pgsql-general(at)postgresql(dot)org>
Subject: leap day bug after 1901
Date: 1999-04-12 08:05:11
Message-ID: 3711A937.625B06C3@sferacarta.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

Seems that PostgreSQL checks for leap day only before 1902.

prova=> select date '0001-02-29';
ERROR: date_in: day must be limited to values 1 through 28 in
'0001-02-29'

prova=> select date '1701-02-29';
ERROR: date_in: day must be limited to values 1 through 28 in
'1701-02-29'

prova=> select date '1901-02-29';
ERROR: date_in: day must be limited to values 1 through 28 in
'1901-02-29'

prova=> select date '1902-02-29';
?column?
----------
1902-03-01
(1 row)

José

Responses

Browse pgsql-general by date

  From Date Subject
Next Message José Soares 1999-04-12 08:42:13 Gregorian Calendar
Previous Message Igor V. Kruchinsky 1999-04-12 07:40:08