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 vote207 views1 answer
Setval in postgres
SQL
1 vote266 views1 answer
Sqlite show columns in table
SQL
1 vote216 views1 answer
Mysql add fields
SQL
0 vote194 views1 answer
Shrink database file in sql server
SQL
3 votes212 views2 answers
Mysql config user password
SQL
2 votes202 views1 answer
Oracle calculated column
SQL
1 vote197 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
16 votes206 views2 answers
Add column if not exists mysql
SQL
0 vote230 views2 answers
What is rownum in oracle
SQL
2 votes238 views1 answer
Sql get the name of user pc
SQL