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 vote119 views3 answers
Run sql command line
SQL
22 votes121 views1 answer
Mysql workbench
SQL
5 votes100 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote96 views1 answer
Strat with in sql
SQL
33 votes97 views2 answers
Postgres how to add field created at
SQL
0 vote103 views1 answer
How to check default value of column in sql server
SQL
2 votes116 views1 answer
Mysql id of inserted row
SQL
0 vote97 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote115 views1 answer
How to combine first and last nae into one columb sql
SQL
1 vote147 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL