Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

NUMTODSINTERVAL()

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.