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 vote120 views1 answer
Renommer base sql
SQL
0 vote106 views2 answers
Update all columns in one update
SQL
0 vote116 views1 answer
Rails sql query converstion
SQL
0 vote106 views2 answers
Pop sql insert value into
SQL
0 vote120 views1 answer
Sql update subtract value
SQL
2 votes117 views2 answers
Sql lag
SQL
0 vote120 views1 answer
Mysql change timestamp on update
SQL
5 votes271 views2 answers
How to ascending order in sql
SQL
4 votes236 views2 answers
Sql display today's date
SQL
0 vote113 views1 answer
Convert uniqueidentifier to varchar in sql
SQL