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

23 votes161 views3 answers
Sql where contains part of string
SQL
5 votes192 views1 answer
Migrate sql table another database
SQL
0 vote106 views1 answer
Mssql view column data type
SQL
1 vote151 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote150 views1 answer
Sql join on a subquery
SQL
0 vote157 views3 answers
Group_concat sql server
SQL
4 votes146 views3 answers
Sql drop database if exists
SQL
0 vote151 views1 answer
Char varchar nvarchar sql
SQL
0 vote165 views3 answers
Duplicate row mysql
SQL
0 vote168 views1 answer
Connect to ssms with python
SQL