For Testing I need test cases in 3 categories:
1. 10 Cases where Close Date (actual close date of Complaint) is more than 8 years prior to current date
2. 10 cases where Close Date (actual close date) is less than 8 years but still prior to current date
3. 10 cases where Close Date is 12/31/9999 default date since these will not be closed.
How do I select records satisfying these conditions
I googled and found out this solution
where DATE_END < SYSDATE - 2920
// CALCULATED 8*365 = 2920 DAYS
and I am looking for a better solution.. Please help experts....