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

0 vote132 views1 answer
Resulting Query
SQL
0 vote147 views1 answer
Drop procedure sql
SQL
0 vote141 views1 answer
Mysql drop trigger
SQL
0 vote146 views1 answer
Setval postgres example table id
SQL
6 votes96 views2 answers
Spring data jpa application.properties mysql
SQL
4 votes146 views6 answers
List all tables in postgres
SQL
0 vote160 views1 answer
How convert into in in sql query
SQL
0 vote148 views1 answer
Oracle cpu metric
SQL
0 vote140 views1 answer
Asp.net core sql server stored procedure
SQL
1 vote145 views1 answer
How to select rows with no matching entry in another table?
SQL