title: How To Get YEARWEEK() To See Sunday As The Start Of The Week?
body: <p>I'm trying to get the YEARWEEK function to see Sunday as the 1st day of the week.</p>
  
  <p>An example date is: Sunday 1st Mar 2009</p>
  
  <p>Here is my sql</p>
  
  <pre><code>SELECT YEARWEEK('2009-03-01')
  </code></pre>
  
  <p>and the result is</p>
  
  <p>-> 200909</p>
  
  <p>Which is week 9. I believe it is telling me this is week 9 because it sees the sunday as the last day of the previous week.</p>
  
  <p>How would I get this function to see sunday as the 1st day of the week and therefore return as week 10?</p>