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

14 votes172 views3 answers
Sql trim from string
SQL
1 vote187 views1 answer
Tsql replace value in json
SQL
1 vote240 views1 answer
Size of all tables in a schema oracle
SQL
11 votes176 views1 answer
Sql query to find duplicates in column
SQL
1 vote185 views2 answers
Mysql switch case
SQL
2 votes178 views1 answer
Oracle convert run_duration to number
SQL
5 votes191 views2 answers
Postgresql add not null constraint
SQL
1 vote190 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
5 votes160 views1 answer
Sql select ciunt
SQL
0 vote183 views2 answers
Advantages of stored procedures sql
SQL