Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Select add_months( sysdate, 12 ) Next Year

SQL> -- SQL> SQL> SQL> select add_months( sysdate, 12 ) "Next Year"   2  from dual; Next Year --------- 16-JUN-09 1 row selected. SQL> SQL> --