Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

BETWEEN 30 and 60 days

NITS_BAMar 18 2014 — edited Mar 18 2014

I have this query:

SELECT INL.INV_ID,CS.CUST_ID ,CS.CUST_ACTIVE_DEFECTING,INL.ITM_QTY

FROM MGC.INVOICE_LINES INL, MGC.INVOICES INV, MGC.CUSTOMERS CS

WHERE INL.INV_ID = INV.INV_ID

AND INV.BILL_CUST_ID = CS.CUST_ID

AND CS.CUST_ACTIVE_DEFECTING = 'Y'

;

I want to find info between 30 and 60 days. I am trying to figure out using SYSdate - INV.INV_CLOSE_DATE in the query and get the results between 30 and 60 days.

Thanks,

Tom

This post has been answered by Solomon Yakobson on Mar 18 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2014
Added on Mar 18 2014
7 comments
520 views