TO_DSINTERVAL « Date Timezone « Oracle PL / SQL






1.TO_DSINTERVAL(x): Convert the string x to an INTERVAL DAY TO SECOND
2.select sysdate - to_dsinterval( '1 00:00:00' ) "US Marines Birthday"
3.start_date+TO_DSINTERVAL('100 10:00:00')