Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Previous Month function

Previous Month function

From: aolsen <aolsenNOsuSPAM_at_assure.ca>
Date: Wed, 18 Aug 1999 07:04:53 -0700
Message-ID: <0a0133f8.50c10d42@usw-ex0106-043.remarq.com>


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



01-FEB-99 Anna Received on Wed Aug 18 1999 - 09:04:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US