General information
Forum:
Microsoft SQL Server
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only