title: BigQuery: Selecting the week from Google Analytics data using standard SQL
body: <p>I'm working with Google Analytics data in a Google Big Query table using standard sql. I wish to select group data at a weekly level. I've found this solution:</p>
  
  <pre><code>SELECT FORMAT_TIMESTAMP("%W", PARSE_TIMESTAMP("%Y%m%d", '20150519'))
  </code></pre>
  
  <p>Outputs:</p>
  
  <pre><code>20
  </code></pre>
  
  <p>Is there a shorter method to get to this point? It seem quite long to me and I'm wondering if I'm missing a trick.</p>