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 vote191 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote242 views1 answer
Sql create and grant user access to database
SQL
0 vote208 views2 answers
Transaction php
SQL
0 vote188 views1 answer
Rollback to name in sql
SQL
0 vote211 views1 answer
Mysql get last 2 month data
SQL
0 vote218 views1 answer
Sql server get date of previous sunday
SQL
1 vote202 views1 answer
How to test for sql injection
SQL
0 vote197 views1 answer
Concat column value of same user in mysql
SQL
4 votes158 views1 answer
And or sql order of operations
SQL
0 vote212 views1 answer
Sqlalchemy case insensitive like
SQL