SQL Server: Date and Time Data Types (Size and Ranges)

hnrsj

Thank you for this reference, whomever made this chart!

Tip: DateTime2(3) has the same number of digits as DateTime but uses 7 bytes of storage instead of 8 bytes (SQLHINTS- DateTime Vs DateTime2).

Advertisements