Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Select add_months( sysdate, -12 ) Last Year

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