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

4 votes1.1K views1 answer
Oracle show errors
SQL
0 vote303 views1 answer
Find wordpress version in database
SQL
0 vote298 views1 answer
Update using case in mysql
SQL
0 vote318 views2 answers
Nodejs mysql convert to plain object
SQL
1 vote306 views1 answer
Mysql dump specific tables
SQL
0 vote259 views1 answer
Oracle sysdba connect as another user
SQL
13 votes298 views5 answers
Select last row mysql
SQL
0 vote295 views1 answer
Mssql current date
SQL
0 vote325 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
0 vote287 views1 answer
Clone table structure mysql
SQL