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

3 votes237 views4 answers
Mysql create table from select statement
SQL
0 vote192 views1 answer
Acual month sql
SQL
0 vote209 views1 answer
Mssql + bit + in python orm
SQL
6 votes192 views2 answers
Mysql get yesterday
SQL
0 vote205 views1 answer
Sqlite3 get data from table c
SQL
2 votes181 views1 answer
How to delete columns in sql
SQL
36 votes198 views6 answers
Delete from where sql
SQL
2 votes152 views1 answer
Sql select min value from multiple columns
SQL
1 vote254 views2 answers
Sql split string by space
SQL
3 votes186 views2 answers
Find the median in sql
SQL