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 vote331 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
0 vote336 views2 answers
Postgres show current role
SQL
0 vote356 views1 answer
Influxdb list all tags for a measurement
SQL
10 votes325 views4 answers
Inner join in update query mysql
SQL
8 votes346 views1 answer
How to check mysql version in xampp
SQL
1 vote353 views1 answer
Sql how to replace full stop
SQL
3 votes334 views3 answers
Start postgresql ubuntu
SQL
0 vote332 views2 answers
PostgreSQL having
SQL
0 vote309 views1 answer
First mysql
SQL
1 vote392 views1 answer
OSError: mysql_config not found
SQL