title: Oracle SQL query - get data from last week (Monday-Saturday)
body: <p>I'm working on a query that would show data added in last week (always beginning with Monday), from <strong><em>COLUMNNAME</em></strong>, <strong><em>TABLENAME</em></strong>. I also have a column with dates, <strong><em>adddate</em></strong>.
  It seems not to work... How would I fix it?</p>
  
  <pre><code>select COLUMNNAME
  from TABLENAME 
  
  where adddate &gt;= (TRUNC(adddate - 7 - (TRUNC (adddate)- TRUNC (adddedate, 'IW'))))
  and adddate &lt; (TRUNC(adddate - 7 - (TRUNC (adddate)- TRUNC (adddedate, 'IW'))))+6
  </code></pre>