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.