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 vote358 views1 answer
Postgres select from values
SQL
0 vote415 views3 answers
How to find all role in mysql
SQL
2 votes408 views2 answers
Null column to 0 in mysql
SQL
0 vote376 views1 answer
Oracle list of long running queries
SQL
0 vote368 views2 answers
Postgresql gset
SQL
0 vote347 views1 answer
Postgres where
SQL
0 vote502 views1 answer
Sql insert exemplo
SQL
2 votes341 views2 answers
Mysql on duplicate key ignore
SQL
5 votes367 views1 answer
Mysql count newlines in field
SQL
4 votes376 views2 answers
Truncate oracle
SQL