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 vote250 views1 answer
Oracle job session
SQL
3 votes249 views2 answers
Coalesce mysql
SQL
0 vote264 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote260 views1 answer
How to login to mysql in homestead
SQL
0 vote288 views1 answer
Hibernate dialect property xml for mysql 8
SQL
4 votes276 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
19 votes258 views5 answers
Change column name mysql command line
SQL
10 votes295 views6 answers
Mysql set root password
SQL
0 vote281 views1 answer
View t-sql mail configuration
SQL
0 vote279 views1 answer
Firebase sql
SQL