Number of days between last pay and today

[Mike Hughes]

I'm looking to pickup the cases where the date last paid is greater than 60 days. Can someone help me

select id_case,
dt_last_pay
from noldba.case_rollup;

 

[pdx_man]

select id_case,
dt_last_pay
from noldba.case_rollup;
where datediff("d",DT_last_pay, Date()) > 60

 

[Mike Hughes]

I get an error ORA-00936 Missing Expression

 

[pdx_man]

Does the SQL you posted work?

 

[boblarson]

select id_case,
dt_last_pay
from noldba.case_rollup;
where datediff("d",DT_last_pay, Date()) > 60

get rid of the semi colon after the word rollup and move it to the end of everything (after 60)