title: MYSQL query start time and end time
body: <p>How would I display with mysql the start time and end time from the current week (starting Sunday) with an interval of 2 weeks?</p>
  
  <p>Example:</p>
  
  <pre><code>id  starttime            endtime
  2   2015-02-06 09:17:25  2015-02-06 12:17:25
  2   2015-01-15 09:17:25  2015-01-15 12:17:25
  </code></pre>
  
  <p>The <strong>result</strong> would just display the first field because it is a "new week" and the first field is from a previous month. </p>