Convert number to interval in oracle using NUMTODSINTERVAL function

This explains how to convert the given number to the interval (which can be days, hours, minutes, or seconds) in the oracle using the NUMTODSINTERVAL conversion function

There is a conversion function in oracle by the name, NUMTODSINTERVAL which converts the specified number to the desired interval. The interval can be either of day, hour, minute or second.

Syntax: NUMTODSINTERVAL(n, Interval)

Here n is the number to be converted, and Interval is the unit that’s needs to be converted to and its values can be DAY, HOUR, MINUTE, or SECOND.

Ex1: SELECT NUMTODSINTERVAL(10,'MINUTE') FROM dual;
This returns “+00 00:10:00.000000” as result

Ex2: SELECT NUMTODSINTERVAL(1000,'MINUTE') FROM dual;
This returns “+00 16:40:00.000000” as result

Ex3: SELECT NUMTODSINTERVAL(1000,'HOUR') FROM dual;
This returns “+41 16:00:00.000000” as result