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 vote437 views2 answers
Create new table from existing table with data in sql server
SQL
0 vote265 views1 answer
Call rest api from postgresql
SQL
-1 vote260 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote264 views1 answer
Mysql set column equal to another automatic
SQL
11 votes259 views1 answer
Ddl materialized view
SQL
4 votes256 views4 answers
Sqlite describe table
SQL
0 vote266 views1 answer
Sql character index
SQL
0 vote270 views1 answer
Oracle sql log to console
SQL
23 votes285 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote280 views1 answer
Left join vs inner join performance
SQL