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

28 votes180 views4 answers
Mysql delete database
SQL
0 vote179 views1 answer
Sql compound operators
SQL
0 vote203 views1 answer
SQL server datetime compare
SQL
0 vote201 views1 answer
Hibernate xml property MySQL url, username and password
SQL
1 vote205 views1 answer
Mysql show attributes of a table
SQL
0 vote207 views1 answer
Firebase sql
SQL
0 vote189 views1 answer
Get week day name sql server
SQL
1 vote183 views1 answer
Autocommit mysql
SQL
0 vote222 views1 answer
Oracle plsql sleep
SQL
0 vote192 views1 answer
IS THEre any difference between using default and := in plsql
SQL