Claudio Silva points out a difference between the DATETIME and DATETIME2 data types:
I’m currently working on a SQL code migration from Firebird to SQL Server and I hit an error that I haven’t seen for some time.
The error message is the following:
Msg 206, Level 16, State 2, Line 4
Operand type clash: datetime2 is incompatible with intThis ringed the bell right away! Somewhere on the code someone was trying to do an arithmetic calculation without using the proper function.
Read on for the solution.