TO_DSINTERVAL(x): Convert the string x to an INTERVAL DAY TO SECOND : TO_DSINTERVAL « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. TO_DSINTERVAL

TO_DSINTERVAL(x): Convert the string x to an INTERVAL DAY TO SECOND



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>








Related examples in the same category

1.select sysdate - to_dsinterval( '1 00:00:00' ) "US Marines Birthday"
2.start_date+TO_DSINTERVAL('100 10:00:00')