Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. 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> --