CODEWITHSUNDEEP
sqlsql-server
Andre Gamboa
Andre Gamboa

Reputation: 64

Beside compatibility with SQL Server 2000 and 2005, is there any other issue to use datetime2

I know datetime2 is faster than datetime and also is using less storage space for the same accuracy. Do you know any other impediment to migrate my fields from datetime to datetime2 rather than compatibility with SQL Server 2000 and 2005?

Thanks in advance.

Upvotes: 1

Views: 64

Answers (1)

Dan Guzman
Dan Guzman

Reputation: 46193

There are no downsides with using datetime2 versus datetime as long as you use datetime2 only or avoid conversions between these two data types.

There is a potentially breaking change in SQL Server 2016 with regards to value rounding when converting between these types that could be an issue depending on your code.

Upvotes: 1

Related Questions