Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. Select extract( year from add_months(sysdate,36) ) 3 Years Out
SQL>
SQL> select extract( year from add_months(sysdate,36) ) "3 Years Out"
  2  from dual;
3 Years Out
-----------
       2011
1 row selected.
SQL>
SQL>
SQL> --