select sysdate - to_dsinterval( '1 00:00:00' ) "US Marines Birthday" : TO_DSINTERVAL « Date Timezone « Oracle PL / SQL






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

select sysdate - to_dsinterval( '1 00:00:00' ) "US Marines Birthday"

 
SQL>
SQL>
SQL>  alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';

Session altered.

SQL>
SQL>  select sysdate from dual;
SYSDATE
--------------------
16-JUN-2008 17:29:01

1 row selected.

SQL>
SQL>
SQL>  select sysdate - to_dsinterval( '1 00:00:00' ) "US Marines Birthday" from dual;
US Marines Birthday
--------------------
15-JUN-2008 17:29:01

1 row selected.

SQL>
SQL> --








Related examples in the same category

1.TO_DSINTERVAL(x): Convert the string x to an INTERVAL DAY TO SECOND
2.start_date+TO_DSINTERVAL('100 10:00:00')