Mega Code Archive
TO_DSINTERVAL(x)
<![CDATA[
SQL> --TO_DSINTERVAL(x): Convert the string x to an INTERVAL DAY TO SECOND.
SQL>
SQL> select TO_DSINTERVAL('100 10:00:00') from dual;
TO_DSINTERVAL('10010:00:00')
---------------------------------------------------------------------------
+000000100 10:00:00.000000000
SQL>
]]>