leap day bug after 1901 - Mailing list pgsql-general

From José Soares
Subject leap day bug after 1901
Date
Msg-id 3711A937.625B06C3@sferacarta.com
Whole thread Raw
List 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é



pgsql-general by date:

Previous
From: "Igor V. Kruchinsky"
Date:
Subject: ...
Next
From: José Soares
Date:
Subject: Gregorian Calendar