Invalid number error - NVL function

Question

I just found out an error (Invalid Number) in this line of SQL code:

WHERE NVL((submit_time - req_time) * 24 ,12121)  != 12121

Can someone explain what may be the problem?

Answer 1

Can you try something like this , to make sure that we are not dealing with null on those two fields

where decode(submit_time,NULL,12121,decode(req_time,null,12121,(submit_time - req_time) * 24))