Mega Code Archive
NUMTODSINTERVAL(x, interval_unit)
<![CDATA[
SQL>
SQL> --NUMTODSINTERVAL(x, interval_unit): convert the number x to an INTERVAL DAY TO SECOND with the interval for x supplied in interval_unit.
SQL>
SQL> SELECT NUMTODSINTERVAL(1.5, 'DAY') FROM dual;
NUMTODSINTERVAL(1.5,'DAY')
---------------------------------------------------------------------------
+000000001 12:00:00.000000000
SQL>
]]>