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 vote140 views1 answer
Oracle list index on table
SQL
5 votes153 views3 answers
Truncate function in sql oracle
SQL
0 vote141 views1 answer
Declare date variable sql
SQL
0 vote162 views3 answers
Sql query checker
SQL
0 vote172 views1 answer
Connecting mySQL to STS
SQL
3 votes163 views2 answers
Sqlite show table structure
SQL
0 vote157 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote142 views1 answer
Oracle last character of string
SQL
0 vote140 views2 answers
Sqlalchemy core in clause
SQL
0 vote207 views1 answer
Osm2pgsql mac
SQL