title: mysql week() function is returning one less number of actual week number
body: <p>I am using week() function from mysql to determine week number from date. Problem what I am facing is that it always return one less number from actual week number. suppose today is 2013-05-15 as it is 20th week of this year but in result it is 19. Following is the query I am using.</p>
  
  <pre><code> SELECT *,WEEK(date_visit) AS week_no FROM property_view_details;
  </code></pre>