Multiple choice technology databases

What's the earliest date that can be stored in a DATETIME data type?

  1. January 1, 1643

  2. January 1, 1753

  3. January 1, 1863

  4. January 1, 1700

  5. January 1, 1800

  6. January 1, 1900

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SQL Server's DATETIME data type can store dates from January 1, 1753 through December 31, 9999. The 1753 lower bound is due to the transition from the Julian to the Gregorian calendar in the British Empire.