Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
From 30/12/1899 but what about under?
Message
From
06/10/2006 16:25:12
 
 
To
06/10/2006 09:50:53
Keith Payne
Technical Marketing Solutions
Florida, United States
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01159585
Message ID:
01160223
Views:
11
Actually the modern day calendar is the Gregorian calendar.

>>>The birth dates are the 14th century of which calendar? This is the problem with storing dates before 1753. One solution is to store these dates as a number of years before X date. It means another column in your table and that the DTS transformation will have to contain some activex script - or - use a VFP view that splits it up into different columns. You won't be able to perform any datetime arithmetic on these dates, but without the precise calendar information including manual adjustments and leap days, any datetime arithmetic is meaningless.
>>
>>The present date calendar, I mean the one we regularly use, is known as the Julian calendar. Isn't it?
>
>Yes, but the Julian calendar is not continous before 1753. There are adjustments that have varying lengths and occur on different days depending on your locale. Some countries had different calendars and some countries were simply on a different day.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform