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 vote314 views1 answer
Sql count value greater than
SQL
0 vote471 views1 answer
Dublicate row sql
SQL
-2 votes282 views1 answer
Use of where in left join in mysql
SQL
0 vote273 views1 answer
Mysql into outfile with headers
SQL
2 votes282 views1 answer
Oracle number to percentage
SQL
12 votes277 views1 answer
Docker run mysql image
SQL
0 vote312 views1 answer
Bitmap join index
SQL
2 votes279 views1 answer
Sql skip the first row
SQL
14 votes304 views2 answers
Install mysqldump
SQL
2 votes296 views1 answer
Mariadb json select
SQL