devxlogo

Importing Dates Earlier Than 1752

Importing Dates Earlier Than 1752

Question:
When I try to import data to SQL, I find a problem in exporting the date values that occur earlier than the year 1752.

Since I am working in Saudi Arabia, I need to use dates like 10/12/1412. How can I do that?

Answer:
SQL Server does not support date data older than 1752 with the date datatypes. When it was designed, Microsoft decided to limit the dates as you have discovered (though I confess I forget why they chose 1752).

I am not sure whether this will work for you, but I’d investigate coding this information as Julian Calendar dates to see if that is an applicable workaround for your situation.

devx-admin

Share the Post: