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 vote125 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
2 votes127 views1 answer
Check isolation level in mysql
SQL
0 vote139 views1 answer
Insert into Select * - NAYCode.com
SQL
4 votes134 views1 answer
Mysql ip address data type
SQL
6 votes122 views1 answer
Oracle trigger after connect
SQL
1 vote126 views1 answer
Create another table from existing table sql oracle
SQL
1 vote118 views1 answer
Oracle rolling back
SQL
1 vote140 views1 answer
Sysdate in sql
SQL
2 votes152 views3 answers
Sql server: how to concatenate column data using comma
SQL
1 vote143 views1 answer
Mysql select and count left join
SQL