SQL Get interval last week (sunday to saturday)
<p>I need a simple sql script where i can grab the rows with a date between sunday 2 weeks ago and saturday the previous week.</p>

<p>I need the query to return the elements no matter what day of this week I run the query.</p>

<p>Lets say I run the query today: Thursday 12. dec 2016. (12-08-2016)</p>

<p>I need to get this interval:</p>

<pre><code>SELECT * FROM table WHERE date BETWEEN '11-27-2016' AND '12-03-2016'
</code></pre>