title: Get current week in postgreSQL
body: <p>I have been searching the web for the proper postgreSQL syntax for current_week. I searched through the link attached but could not get anything fruition out of it <a href="https://www.postgresql.org/docs/9.1/static/functions-datetime.html" rel="nofollow noreferrer">Date/Time</a>. My task is to get Sunday as the start of the week.</p>
  
  <p>I tried same as current_date but it failed:</p>
  
  <pre><code>select current_week
  </code></pre>
  
  <p>There has to be a current week syntax for postgreSQL.</p>