Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Extracting certain months across multiple years
I am trying to extract or show a set of months over multible years,
i.e. show JAN-MAR orders from order table. I don't know how to
eliminate oracle from recognizing the years. Does this make sense? I
can do it for single years with the statement:
SELECT *
FROM ORD
WHERE ORDERDATE Between to_date('01-APR-1986')
AND to_date('30-DEC-1986')
How can I get the same result, say, over a five year period. Thanks in
advance, Joe
Received on Thu Apr 26 2007 - 11:51:11 CDT