title: Getting weekly data from sql
body: <p>I have a table which has a date column ands values according to dates.Normally if i want to select the data between two dates we use the <code>BETWEEN</code> syntax but it brings each day between those 2 values i have given.Is it possible to change it so it brings the dates with sopme interval i have given? For example if do a simple </p>
  
  <pre><code>SELECT * FROM METABLE WHERE DATE BETWEEN '2012-06-11' AND '2012-07-11'
  </code></pre>
  
  <p>It should bring me the dates as:</p>
  
  <pre><code>2012-06-11 myValue Stuff 
  2012-06-12 myValue Stuff 
  .
  .
  .
  2012-07-11 myValue Stuff.
  </code></pre>
  
  <p>IS it possible to change it to,</p>
  
  <pre><code>2012-06-11 myValue Stuff 
  2012-06-18 myValue Stuff 
  2012-06-25 myValue Stuff 
  .
  .
  .
  Until my end date.
  </code></pre>
  
  <p>So this gives me my weekly values.
  How can i achieve that?</p>