Oracle PL/SQL NumToDSInterval Function

The NumToDSInterval function converts a number to an INTERVAL DAY TO SECOND literal.

The NumToDSInterval Function syntax:

numtodsinterval( number, expression )

Example:

select numtodsinterval(20, 'DAY') from dual;

+000000020 00:00:00


select numtodsinterval(2100, 'HOUR') from dual;

+000000087 12:00:00


select numtodsinterval(30000, 'MINUTE') from dual;

+000000020 20:00:00


select numtodsinterval(180000, 'SECOND') from dual;

+000000002 02:00:00