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 vote143 views1 answer
Select a row include list of array with join table SQL
SQL
1 vote106 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
1 vote137 views1 answer
Mysql get domain from url
SQL
0 vote184 views1 answer
Example database query
SQL
0 vote135 views2 answers
Pop sql insert value into
SQL
0 vote150 views1 answer
Test database for sql
SQL
23 votes129 views6 answers
How to create table in sql
SQL
0 vote145 views1 answer
Add super privilege mysql
SQL
0 vote137 views1 answer
Mysql where in keep order
SQL
0 vote148 views1 answer
Sql server on mac m1
SQL