Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Nov 24, 1999

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 Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date