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

6 votes251 views2 answers
Subtr Oracle ?
SQL
11 votes207 views2 answers
Sql rank
SQL
0 vote228 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
1 vote204 views1 answer
Sql injection
SQL
0 vote214 views2 answers
Clear window pl sql
SQL
0 vote219 views1 answer
Replace string in whole database mysql stackoverflow
SQL
1 vote227 views2 answers
One to one and one to many relationship
SQL
0 vote208 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote235 views4 answers
Open mysql port bitnami tomact
SQL
0 vote221 views1 answer
Sql list dates between two dates
SQL