Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Previous Month function
Try using the add_months function with a negative value as
your parameter:
SQL> select add_months('01-MAR-99',-1) from dual;
ADD_MONTH