微软的日历控件为什么从1753年开始？Sqlserver数据库不能插入1753年之前的数据？

很久没写日志了，最近在研究公历与农历的，在用微软的Calendar控件时候，无聊看看它最早能到几几年，惊奇的发现居然只到1753年。

原来，现行的公历是格利戈里历法，这个历法并不是连续的，中间缺少了11天。紧接在1752年9月2日的日期是1752年9月14日。

抹掉这11天是由英国议会在1752年做出的决定。

而微软之所以没加入之前的日期应该是因为之前的日期混乱，各国去掉的11天日期并不统一：

Albania:

December 1912

 

Austria:

Different regions on different dates
Brixen, Salzburg and Tyrol:
        5 Oct 1583 was followed by 16 Oct 1583
Carinthia and Styria:
        14 Dec 1583 was followed by 25 Dec 1583
See also Czechoslovakia and Hungary

 

Belgium:

See the Netherlands

 

Bulgaria:

31 Mar 1916 was followed by 14 Apr 1916

 

Canada:

Different areas changed at different times.
Newfoundland and Hudson Bay coast:
        2 Sep 1752 was followed by 14 Sep 1752
Mainland Nova Scotia:
        Gregorian 1605 - 13 Oct 1710
        Julian 2 Oct 1710 - 2 Sep 1752
        Gregorian since 14 Sep 1752
Rest of Canada:
        Gregorian from first European settlement

 

China:

The Gregorian calendar replaced the Chinese calendar in 1912, but the Gregorian calendar was not used throughout the country until the communist revolution of 1949.

 

Czechoslovakia (i.e. Bohemia and Moravia):

6 Jan 1584 was followed by 17 Jan 1584

 

Denmark (including Norway):

18 Feb 1700 was followed by 1 Mar 1700

 

Egypt:

1875

 

Estonia:

31 Jan 1918 was followed by 14 Feb 1918

 

Finland:

Then part of Sweden. (Note, however, that Finland later became part of Russia, which then still used the Julian calendar. The Gregorian calendar remained official in Finland, but some use of the Julian calendar was made.)

 

France:

9 Dec 1582 was followed by 20 Dec 1582
Alsace: 5 Feb 1682 was followed by 16 Feb 1682
Lorraine: 16 Feb 1760 was followed by 28 Feb 1760
Strasbourg: February 1682

 

Germany:

Different states on different dates:
Catholic states on various dates in 1583-1585
Prussia: 22 Aug 1610 was followed by 2 Sep 1610
Protestant states: 18 Feb 1700 was followed by 1 Mar 1700
(Many local variations)

 

Great Britain and colonies:

2 Sep 1752 was followed by 14 Sep 1752

 

Greece:

[9 Mar 1924 was followed by 23 Mar 1924
(Some sources say 1916 and 1920)]

 

Hungary:

21 Oct 1587 was followed by 1 Nov 1587

 

Ireland:

As Great Britain

 

Italy:

4 Oct 1582 was followed by 15 Oct 1582

 

Japan:

The Gregorian calendar was introduced to supplement the traditional Japanese calendar on 1 Jan 1873.

 

Latvia:

During German occupation 1915 to 1918

 

Lithuania:

1915

 

Luxemburg:

14 Dec 1582 was followed by 25 Dec 1582

 

Netherlands:

Zeeland, Brabrant, and the ``Staten Generaal'':
        14 Dec 1582 was followed by 25 Dec 1582
Holland:
        1 Jan 1583 was followed by 12 Jan 1583
Limburg and the southern provinces (currently Belgium):
          20 Dec 1582 was followed by 31 Dec 1582
        or
          21 Dec 1582 was followed by 1 Jan 1583
Groningen:
        10 Feb 1583 was followed by 21 Feb 1583
        Went back to Julian in the summer of 1594
        31 Dec 1700 was followed by 12 Jan 1701
Gelderland:
        30 Jun 1700 was followed by 12 Jul 1700
Utrecht and Overijssel:
        30 Nov 1700 was followed by 12 Dec 1700
Friesland:
        31 Dec 1700 was followed by 12 Jan 1701
Drenthe:
        30 Apr 1701 was followed by 12 May 1701

 

Norway:

Then part of Denmark.

 

Poland:

4 Oct 1582 was followed by 15 Oct 1582

 

Portugal:

4 Oct 1582 was followed by 15 Oct 1582

 

Romania:

31 Mar 1919 was followed by 14 Apr 1919
[The Greek Orthodox parts of the country may have changed later.]

 

Russia:

31 Jan 1918 was followed by 14 Feb 1918
[In the eastern parts of the country the change may not have occurred until 1920.]

 

Scotland:

See Great Britain

 

Spain:

4 Oct 1582 was followed by 15 Oct 1582

 

Sweden (including Finland):

17 Feb 1753 was followed by 1 Mar 1753 (see note below)

 

Switzerland:

Catholic cantons: 1583, 1584 or 1597
Protestant cantons:
        31 Dec 1700 was followed by 12 Jan 1701
(Many local variations)

 

Turkey:

Gregorian calendar introduced 1 Jan 1927

 

USA:

Different areas changed at different times.
Along the Eastern seaboard: With Great Britain in 1752.
Mississippi valley: With France in 1582.
Texas, Florida, California, Nevada, Arizona, New Mexico: With Spain in 1582
Washington, Oregon: With Britain in 1752.
Alaska: October 1867 when Alaska became part of the USA.

 

Wales:

See Great Britain

 

Yugoslavia:

1919

 

 

所以，微软就直接从1753年开始啦··具体的大家可以看http://www.tondering.dk/claus/cal/node3.html#SECTION00311000000000000000