title: Change start day of the week impala
body: <p>I am trying to change the start day of the week, but not able to achieve
  currently its Monday to sunday, it should be made sunday- saturday
  I tried using this query on the below dataset <code>invoice date</code> and <code>invoice_week</code></p>
  
  <pre><code> SELECT invoice_date,
          weekofyear(invoice_date) as invoice_week,
          datesub(invoice_date,1),
          weekofyear(datesub(invoice_date,1)) as invoice_week1 
     from table
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/UaPnB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UaPnB.png" alt="enter image description here"></a></p>