title: Bigquery Custom first day of week (defaults Monday)
body: <p>I am trying to extract week from date using the function </p>
  
  <blockquote>
    <p>format_timestamp('%V', DATE)</p>
  </blockquote>
  
  <p>but Bigquery documentation says "Monday as the first day of the week".</p>
  
  <p>Is there a way where I can specify Tuesday as first day of week.</p>
  
  <p>I have achieved the same in Redshift using </p>
  
  <blockquote>
    <p>date_part(week, date + interval '-1 day')</p>
  </blockquote>
  
  <p>Is it possible in Bigquery?</p>