Error comparing ORA-00932 dates

Question

I’m having a problem comparing two dates in the oracle. I’m using the case method to compare the dates and at the end this should return to my table a number, which in the case represents an age, however, I get p error stating:

PL/SQL: ORA-00932: inconsistent data types: expected DATE got NUMBER.

Below is the code snippet that gives the error.

(case when T1.ANO_MODELO = 0 then 0 else (case when ((W_REG.DAT_ENVIO_CALCULO) - T1.ANO_MODELO) < 0 then 0 else ((W_REG.DAT_ENVIO_CALCULO) - T1.ANO_MODELO) End) End)

Answer 1

All the results of your marry must return the same data type. The error occurs because in a situation it returns a number and in another situation returns a date.

The W_REG.DAT_ENVIO_CALCULO is a date? The T1.ANO_MODELO is a number?

---

[EDIT]

Where do you do:

((W_REG.DAT_ENVIO_CALCULO) - T1.ANO_MODELO)

Replace with:

trunc(
(
W_REG.DAT_ENVIO_CALCULO - to_date(extract(day from W_REG.DAT_ENVIO_CALCULO) || '/' || extract(month from W_REG.DAT_ENVIO_CALCULO) || '/' || T1.ANO_MODELO, 'dd/mm/yyyy')
) / 365 )

This "formula" will return you an integer value that represents the number of years of the vehicle. Do a test and see if you solve.