Function Description
NUMTODSINTERVAL(x, interval_unit)Converts the number x to an INTERVAL DAY TO SECOND with the interval for x supplied in interval_unit, which you may set to DAY, HOUR, MINUTE, or SECOND.
NUMTOYMINTERVAL(x, interval_unit)Converts the number x to an INTERVAL YEAR TO MONTH with the interval for x supplied in interval_unit, which you may set to YEAR or MONTH.
TO_DSINTERVAL(x)Converts the string x to an INTERVAL DAY TO SECOND.
TO_YMINTERVAL(x)Converts the string x to an INTERVAL YEAR TO MONTH.