-1

I want to get data in oracle for more than 90 days from todays date. So I wrote the below query for fetching the data.

select a.span_id, a.link_id, b.rejected_date
 from tbl_fiber_inv_jobs a
 inner join tbl_fiber_inv_job_progress b
 on a.job_id = b.job_id
 where b.rejected_date is not null
 and b.rejected_date >= TRUNC(sysdate)-90;

But it's not fetching the data properly. Please let me know whether I am writing proper query or not for fetching data.

Nad
  • 4,605
  • 11
  • 71
  • 160

1 Answers1

2

I want to get data in oracle for more than 90 days from todays date

To me, it looks like

and b.rejected_date <= TRUNC(sysdate)-90
Littlefoot
  • 131,892
  • 15
  • 35
  • 57