Date Timestamp Functions Oracle PLSQL Tutorial

NUMTODSINTERVAL(x, interval_unit) converts the number x to an INTERVAL DAY TO SECOND with the interval for x supplied in interval_unit.
You may set interval_unit to DAY , HOUR , MINUTE , or SECOND.