Date/Time Data Types

Question 1

datetime

Answer 1

From January 1, 1753 to December 31, 9999 with an accuracy of 3.33 milliseconds

Question 2

datetime2

Answer 2

From January 1, 0001 to December 31, 9999 with an accuracy of 100 nanoseconds

Question 3

smalldatetime

Answer 3

From January 1, 1900 to June 6, 2079 with an accuracy of 1 minute

Question 4

date

Answer 4

Store a date only. From January 1, 0001 to December 31, 9999

Question 5

time

Answer 5

Store a time only to an accuracy of 100 nanoseconds

Question 6

datatimeoffset

Answer 6

The same as datetime2 with the addition of a time zone offset

Question 7

timestamp

Answer 7

Stores a unique number that gets updated every time a row gets created or modified. The timestamp value is based upon an internal clock and does not correspond to real time. Each table may have only one timestamp variable

Question 8

Format of datetime

Answer 8

YYYY-MM-DD HH:MI:SS

Question 9

format of date

Answer 9

YYYY-MM-DD

Question 10

format of smalldatetime

Answer 10

YYYY-MM-DD HH:MI:SS

Question 11

format of timestamp

Answer 11

a unique number