title: How to get the week number based on today date
body: <p>I am trying to select the current date based on the weeknumber in the weekstu table.</p>
  
  <p>so lets says we are in week <code>1</code> which started <code>Monday</code> the <code>25/11/2013</code>. I am trying to get that date based on using today date which is the 28/11/2013. Week <code>2</code> will be the Monday the <code>2/12/2013</code>. The query I have below doesn't return any record. Is this possible to get the beginning of the week based on today date?</p>
  
  <pre><code>table:weekstu
  weekid
  startdate
  setid
  weeknumber
  startdate
  
  Table:week
  weekid
  setid
  
  
      SELECT * from weekstu ws
     JOIN week w ON ws.setid = w.setid AND ws.weekid ON w.weekid
     WHERE ws.weeknumber = `1` AND startdate = CURRENT_TIMESTAMP
  </code></pre>