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 vote184 views1 answer
Create tables from xsd to sql server database c#
SQL
24 votes175 views4 answers
Mssql get all table names
SQL
33 votes169 views6 answers
Sql delete
SQL
3 votes161 views1 answer
Mysql UPDate with enner join
SQL
0 vote116 views1 answer
Sql query with date
SQL
0 vote185 views1 answer
Django mssql backend
SQL
0 vote172 views1 answer
Sql dmv to capture updates
SQL
2 votes196 views1 answer
Sql update \
SQL
1 vote218 views1 answer
Select not matching data with join table
SQL
0 vote178 views1 answer
Mysql not defined
SQL