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 vote123 views1 answer
If exist column in table drop sql query mysql
SQL
0 vote144 views2 answers
Nodejs mysql convert to plain object
SQL
0 vote134 views1 answer
Match end of string regex sql
SQL
2 votes148 views1 answer
Sql get the name of user pc
SQL
1 vote95 views1 answer
Mysql show attributes of a table
SQL
94 votes176 views4 answers
Create database postgres
SQL
0 vote138 views1 answer
Joomla execute raw sql
SQL
0 vote175 views1 answer
Sqlalchemy query return only n results
SQL
0 vote128 views1 answer
Pl sql constraint user function
SQL
13 votes129 views5 answers
Oracle list tables
SQL