Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Previous Month function
Use this ADD_MONTHS(sysdate, -1)
john bruin <jbruin_at_tssc.co.nz> wrote in message
news:37BA05BA.4CE9_at_tssc.co.nz...
> Does anyone know if there is a function to select records for the
> previous month. In the past we have run a query on the 1st day of the
> month and selected for the previous 31 days ("sydate -31") which is OK
> but requires sorting/deletion of unwanted records for the months that
> have 30 days or less.
>
> Any help appreciated,
> John
Received on Tue Aug 17 1999 - 20:29:01 CDT