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 vote198 views1 answer
Mssql unique key accept nulls
SQL
0 vote220 views1 answer
Sqlite schema structure of a relational database
SQL
2 votes180 views1 answer
Set boolean flasksql
SQL
0 vote179 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
0 vote179 views1 answer
Postgresql remove new line from string
SQL
0 vote173 views1 answer
Sql row number in result set
SQL
6 votes188 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote179 views2 answers
Restart identity cascade
SQL
20 votes177 views2 answers
Counting in sql
SQL
0 vote221 views1 answer
Select year from dual oracle
SQL