Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Previous Month function
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:00:42 CDT