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

Leave a Reply Cancel reply

Enter your comment here...

Please log in using one of these methods to post your comment:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Google account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

%d bloggers like this:

Share this:

Like this:

Related

Leave a Reply Cancel reply