Gregorian Calendar

From: José Soares <jose(at)sferacarta(dot)com>
To: hackers <pgsql-hackers(at)postgresql(dot)org>, general <pgsql-general(at)postgresql(dot)org>
Subject: Gregorian Calendar
Date: 1999-04-12 08:42:13
Message-ID: 3711B1E5.80213DF6@sferacarta.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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é

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Mount 1999-04-12 08:56:20 RE: [HACKERS] Gregorian Calendar
Previous Message José Soares 1999-04-12 08:05:11 leap day bug after 1901