Tag: datetime

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

Post author By Protiguous
Post date 2019-09-10
No Comments on SQL Server: Date and Time Data Types (Size and Ranges)

SQL Server Date and Time data types and storage spaces. — Thank you for this reference chart, whoever made this!

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).

Tags date, datetime, datetime2, datetimeoffest, hint, minute, nanoseconds, optimize, second, smalldatetime, time, tip