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
SQL Server: Date and Time Data Types (Size and Ranges)
