Why does Microsoft's calendar control start from January 1, 1753? Why cannot I insert data from the SQL Server database before January 1, 1753?

Source: Internet
Author: User

I haven't written any logs for a long time. I recently studied the Gregorian and lunar calendar. When I used Microsoft's calendar control, I was bored to see how many years it could last. I was surprised to find that it was only in 1753.

It turns out that the current Gregorian calendar is the gelgori calendar, which is not consecutive and lacks 11 days in the middle. The date that follows September 2, 1752 is September 14, 1752.

It was the decision of the British Parliament on 1752 to erase these 11 days.

The reason why Microsoft did not join the previous date should be because of the chaos of the previous date. The 11-Day dates removed by countries are not uniform:

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
(Repeated 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 Japan 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,158 4 or 1597
Protestant cantons:
31 Dec 1700 was followed by 12 Jan 1701
(Repeated 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

So, Microsoft has been directly starting from 1753.-specific people can see http://www.tondering.dk/claus/cal/node3.html#SECTION00311000000000000000

Related Article
Large-Scale Price Reduction
  • 59% Max. and 23% Avg.
  • Price Reduction for Core Products
  • Price Reduction in Multiple Regions
undefined. /
Connect with us on Discord
  • Secure, anonymous group chat without disturbance
  • Stay updated on campaigns, new products, and more
  • Support for all your questions
undefined. /
Free Tier
  • Start free from ECS to Big Data
  • Get Started in 3 Simple Steps
  • Try ECS t5 1C1G
undefined. /

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

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.