微軟的日曆控制項為什麼從1753年開始?Sqlserver資料庫不能插入1753年之前的資料?

來源:互聯網
上載者:User

很久沒寫日誌了,最近在研究西曆與農曆的,在用微軟的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

相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.