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>
Home »
Oracle »
Conversion Functions » 

Related: