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

1 vote174 views1 answer
Postgres killing connections on db
SQL
0 vote294 views1 answer
Setting default value for Boolean data type in SQL
SQL
16 votes203 views5 answers
Select last row in sql
SQL
25 votes192 views5 answers
Date in mysql
SQL
0 vote180 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote183 views1 answer
Sql select upcoming birthdays
SQL
1 vote167 views1 answer
Oracle rolling back
SQL
0 vote189 views1 answer
Apt install sql server
SQL
0 vote201 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote236 views1 answer
Show all mongodb
SQL