Question: how to find records between two dates in oracle?
Answer: Select the Data from the Table Between Two Date Ranges. select * from periodtable where start_date = to_date(to_char(sysdate, 'YYYYMM'),'yyyymm') ; select * from periodtable where start_date = to_date(to_char(add_months(sysdate,-30),'yyyymm'),'yyyymm');