Sql server datetime vs datetime2

The MSDN documentation for datetime recommends using datetime2. Here is their recommendation:

Use the time, date, datetime2 and datetimeoffset data types for new work. These types align with the SQL Standard. They are more portable. time, datetime2 and datetimeoffset provide more seconds precision. datetimeoffset provides time zone support for globally deployed applications.

datetime2 has larger date range, a larger default fractional precision, and optional user-specified precision. Also depending on the user-specified precision it may use less storage.

Source: stackoverflow.com

Similar codes

2 votes121 views1 answer
Install sqlite npm
SQL
21 votes128 views6 answers
Docker run mysql
SQL
0 vote124 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
0 vote147 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
5 votes130 views1 answer
Oracle ora-00054 resource busy
SQL
0 vote143 views1 answer
Default password for mysql_secure_installation in mac
SQL
1 vote138 views2 answers
Oracle leftmost characters
SQL
0 vote130 views1 answer
SQL FROM-Klausel
SQL
2 votes115 views1 answer
Sql update alias
SQL
0 vote116 views1 answer
Oracle free up space in tablespace
SQL