title: Start of week number in an year - Snowflakes
body: <p>Week number of 2021 starts with 53. I would want it to be 1. Every year week number has to reset and start with 1.</p>
  <p>Example below query returns 1 in sql</p>
  <pre><code>select datepart(week,'2021-01-01')
  </code></pre>
  <p>But select week('2021-01-01'::date) return 53 in Snowflakes. I need the result to be 1 in snowflakes.</p>