sql query erro

we have recently upgraded our NPM version to 2019.4.

So we have to upgrade our DB too which is now 2017.

While running a report on datetime table, have received the error as below.

"operand type clash datetime2 is incompatible with int"

use below query for volume and it is resolved for volume DateTime BETWEEN '10-01-2020' AND '10-31-2020'.

Used same for CPU and memory usage table, but it ends with an error as "explicit conversion from data type datetime2 to float is not allowed"

Any suggestion, please let me know.

Find more posts tagged with

CPU/Memory & Volume data is stored in two separate table. can you check with datatype DATETIME?

Is this a custom SQL report? You could try Cast(ColumnWithProblem as DateTime)