title: Query to fetch effective from last 7 days
body: <p>I have a table xx_asg with :</p>
  
  <pre><code>Effective_start_date Effective_end_date  Person_number
  03-jan-2016           31-DEC-4712            12
  20-Feb-2015           02-Jan-2016            12
  28-Mar-2015           31-Dec-4712            10
  07-dec-2016           31-Dec-4712            9
  </code></pre>
  
  <p>if i write :</p>
  
  <pre><code>select * from xx_asg
  where trunc(sysdate) between effective_start_date and effective_end_date;
  </code></pre>
  
  <p>This gives me all latest records from this table.</p>
  
  <p>Now If i write :</p>
  
  <pre><code>select * from xx_asg
      where trunc(sysdate) - 7 between effective_start_date and effective_end_date;
  </code></pre>
  
  <p>This gives me records effective from 01-Dec-2016. This query will not return any detail of person_number 9 as its effective from 07-dec-2016 and not 01-dec-2016.</p>
  
  <p>What can i change in my query to fetch all records effective from 01-DEC-2016 / sysdate - 7 till today or 07-dec-2016</p>