Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

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