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 vote189 views1 answer
Setval in postgres
SQL
1 vote173 views1 answer
Foreign key constraint in ms sql
SQL
5 votes177 views2 answers
Sql number columns
SQL
4 votes197 views3 answers
Count with where
SQL
1 vote206 views1 answer
Minus vs intersect in sql
SQL
1 vote182 views1 answer
Postgres set column equal to another
SQL
0 vote174 views1 answer
View t-sql mail configuration
SQL
3 votes178 views2 answers
Postgresql remove not null constraint
SQL
0 vote380 views1 answer
Why do we need data structure in sql
SQL
-1 vote200 views1 answer
Sql set max value in column
SQL