title: Is it possible to set mySQL to have a saturday as the start of the week?
body: <p>Is it possible to set mySQL to have a saturday as the start of the week?</p>
  
  <p>I'm trying to run a query like:</p>
  
  <pre><code>SELECT DISTINCT(week(`date`)) 
    FROM `table` 
   WHERE `date` BETWEEN '2010-08-14' AND '2010-08-27'
  </code></pre>
  
  <p>But the week starts on a Saturday, not Sunday or Monday.  (It's for a pay period week, not a regular week)
  It seems that the modes for the week function only offer Sunday or Monday as a starting date.</p>
  
  <p>I've read that setting default_week_format can help but I don't think that will work for me as this is for specific reports only, not the entire system.</p>
  
  <p>Do I have any other options?</p>