Get current week in postgreSQL
<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>