TO_DSINTERVAL
TO_DSINTERVAL
converts the string x to an INTERVAL DAY TO SECOND
.
SQL> select to_dsinterval('15 09:30:00') from dual;
TO_DSINTERVAL('1509:30:00')
-------------------------------------------------------------
+000000015 09:30:00.000000000
SQL> select to_dsinterval('80 13:30:00') from dual;
TO_DSINTERVAL('8013:30:00')
-------------------------------------------------------------
+000000080 13:30:00.000000000
SQL> select to_dsinterval('95 18:30:00') from dual;
TO_DSINTERVAL('9518:30:00')
-------------------------------------------------------------
+000000095 18:30:00.000000000
SQL>