Multiple choice technology databases

What is the best data type to store the birthdays of the US Presidents, starting with George Washington's birthday of February 22, 1732?

  1. DATETIME

  2. SMALLDATETIME

  3. INT

  4. VARCHAR
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

For SQL Server 2000, the DATETIME type only supports dates from January 1, 1753 onwards, which cannot store historical dates like February 22, 1732. Storing dates as INT (days since a reference point) or VARCHAR allows working with pre-1753 dates. This is a SQL Server-specific limitation.

Keep practicing — related questions