getting error missing right parenthesis but i think there is some issue with interval : select max(valdate) from CORE_TOTEM.TOTEM_MONTHEND_COVERAGE
 where valdate<=sysdate and valdate>= DATE_ADD(sysdate, INTERVAL 5 DAY)