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

10 votes285 views2 answers
Doublon sql
SQL
15 votes277 views4 answers
Mysql export database command line
SQL
4 votes222 views2 answers
Postgresql float data type
SQL
0 vote189 views1 answer
Nueva tabla mysql
SQL
0 vote228 views1 answer
Select multiple row from primary key sql
SQL
59 votes7.7K views6 answers
Alter table sql
SQL
0 vote178 views1 answer
Postgres add prefix to primary key
SQL
0 vote193 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote207 views1 answer
Format the money fied with comma in international system using sql
SQL
23 votes187 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL