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 vote253 views1 answer
Having all mysql
SQL
-1 vote249 views3 answers
MySQL shutdown unexpectedly
SQL
3 votes238 views3 answers
Order by postgres
SQL
0 vote217 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote175 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote234 views1 answer
Drop function
SQL
3 votes214 views1 answer
Oracle nextval
SQL
0 vote204 views1 answer
Metada in sql
SQL
5 votes257 views2 answers
Add days in oracle sql
SQL
1 vote243 views1 answer
Sqlalchemy order by descending
SQL