Gregorian Calendar - Mailing list pgsql-general

From José Soares
Subject Gregorian Calendar
Date
Msg-id 3711B1E5.80213DF6@sferacarta.com
Whole thread Raw
Responses Re: [HACKERS] Gregorian Calendar  (Taral <taral@cyberjunkie.com>)
List pgsql-general
Hi all,

I have a question about dates.
The Gregorian reform of calendar skiped 10 days on Oct, 1582.

This reform was accepted by Great Britain and Dominions (including what
is now the USA)
only in 1752.
This is way we have Sep, 1752 like this:

$ cal 9 1752

  September 1752
 S  M Tu  W Th  F  S
            1  2 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30


If I insert a date that doesn't exist PostgreSQL accepts it.
Should it be considered normal ?

prova=> insert into test values('1752-09-10');
INSERT 403408 1
prova=> select * from test;
date
----------
1752-09-10
(1 rows)

José



pgsql-general by date:

Previous
From: José Soares
Date:
Subject: leap day bug after 1901
Next
From: Peter Mount
Date:
Subject: RE: [HACKERS] Gregorian Calendar