title: How to SET DATEFIRST equal to Wednesday in Amazon Redshift
body: <p>In my DimDate table , Week Day start with "Wednesday" and Ends with " Tuesday" , Now i need to generate week numbers accordingly, To achieve that i need to set my date first to Wednesday ? 
  Is there any other possibilities to achieve the below requirement </p>
  
  <p>Please find the below Sample data I need to populate.</p>
  
  <p><img src="https://i.stack.imgur.com/KApmi.png" alt="enter image description here"></p>
  
  <p>As per 2017-01-01 day starts with Sunday which is default datefirst , but in my case i need to give daynumber for that is 2017-01-01 daynumber= 4 and week =1, 2017-01-02 daynumber =5, 2017-01-01 daynumber= 6 and week =1 
  next Wednesday 01-04-2017 is daynumebr = 0 and week = 2  and so on ......</p>