1
vote
Accepted
Datetime2 in SQL 2014 Vs SQL 2022
Will there be any simple fix to this?
The only 'simple fix' is to run the database at a compatibility level below 130 until your code is ready for the behavioural changes.
For example:
ALTER DATABASE ...
- 90.3k
1
vote
Datetime2 in SQL 2014 Vs SQL 2022
The simplest fix is to cast or convert DateTime2 columns to a uniform precision as DATETIME2(3) in your queries, however, this is short-term. You can use the CONVERT or CAST function to mimic SQL ...
- 384
Only top scored, non community-wiki answers of a minimum length are eligible