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 vote206 views1 answer
Psql show db
SQL
1 vote189 views2 answers
Mysql filter by date mount
SQL
0 vote189 views1 answer
Back up stored procedures mysql
SQL
14 votes189 views2 answers
How to auto increment in sql
SQL
1 vote183 views1 answer
Jooq convert using gbk
SQL
0 vote196 views1 answer
Comparing with today and yesterday record in sql query
SQL
2 votes178 views1 answer
Oracle run_duration average
SQL
0 vote187 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote200 views1 answer
Mysql query with sql to get the next row
SQL
0 vote175 views1 answer
Oracle activate program
SQL