TO_DSINTERVAL « Date Timezone « Oracle PL / SQL

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




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')