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 vote346 views1 answer
Power bi connect to postgresql
SQL
0 vote166 views1 answer
Select from another database
SQL
0 vote163 views1 answer
Sql include rows with 0 values
SQL
11 votes179 views1 answer
Creating tables in sql with python
SQL
0 vote179 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote171 views1 answer
Mysql grant access to one database
SQL
19 votes181 views5 answers
Date between in mysql
SQL
0 vote182 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote155 views1 answer
Stuff in sql server
SQL
3 votes171 views1 answer
Oracle apex warn on unsaved changes
SQL