select add_months( sysdate, -12 ) "Last Year" : ADD_MONTHS « Date Timezone « Oracle PL / SQL






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

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








Related examples in the same category

1.ADD_MONTHS: Schedule a number of months after the current date
2.Subtract Month from a given date
3.Adding one month to SYSDATE
4.Adding two months to current date
5.Combine to_char with add_months
6.select add_months( sysdate, 12 ) "Next Year"