If you do this you can get any month you want, just subtract a different number. You can also create a function based index if you want.
Code:where trunc(order_created_date, 'MM' ) = ADD_MONTHS(TRUNC(SYSDATE, 'MM'), -1)
|
Results 1 to 5 of 5
Thread: date query for previous monthsThreaded View
|
Click Here to Expand Forum to Full Width |