Posted By: jerryiii (Vsude dobre, v CR nejhur) on 'CZdatabases'
Title: Re: rok 1754 v MS SQL serveru
Date: Thu Apr 19 11:03:20 2001
The reason for the early cutoff of possible datetime values isn't mathematical
but historical. In September 1752, Great Britain adopted the Gregorian
calendar, which differed from the one previously used in Great Britain and
its colonies by 12 days. The change happened on September 2, 1752, so the
next day was September 14, 1752.
So, with 12 days lost, how can you compute dates? For example, how can you
compute the number of days between October 12, 1492, and July 4, 1776? Do you
include those missing 12 days? To avoid having to solve this problem, the
original Sybase SQL Server developers decided not to allow dates before 1753.
You can store earlier dates by using character fields, but you can't use any
datetime functions with the earlier dates that you store in character fields.
Mam to prelozit?
Jerry III
Enough said ...
http://jerryiii.home.sprynet.com/mica/index.htm