I work with a couple of databases that require the use dates (to the precision of mm/dd/yyyy) prior to 1753. Are there any kind of updates or custom utilities for SQL 7 that add the use of a DateTime data type that can handle dates prior 1753? This seems to be beyond the scope of the user-defined data types since they are based on the existing data types. Any help would be appreciated. Thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DateTime prior to 1753
- Thread starter tanuki3
- Start date
Not as far as I know. The reason for the 1753 limit is that was the year most of the world changed from the Julian Calendar to the Grgorian Calendar, which involved skipping a 11 days. England switched in Spetember 1753 if I remember correctly with other countries doing it at different times.
As you cna see that maked any type of date math prior to that tricky at best.
Your best bet is to store it as some kind of character field.
As you cna see that maked any type of date math prior to that tricky at best.
Your best bet is to store it as some kind of character field.
- Status
Similar threads
- Locked
- Question
- Question