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

1 vote327 views1 answer
How to put value in variable mysql
SQL
1 vote284 views1 answer
Create temporal table in sql
SQL
0 vote298 views1 answer
Sql server alter table column nullable
SQL
0 vote296 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote285 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
4 votes309 views3 answers
Employee name starting with in sql
SQL
0 vote283 views1 answer
How to save data in database in mysql node
SQL
0 vote368 views1 answer
Mysql get nested records
SQL
0 vote295 views1 answer
How to get data between a last week in mysql
SQL
0 vote291 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL