title: BigQuery Standart SQL: extract day-of-week name from timestamp
body: <p>I'm Using BigQuery <strong>Standart SQL.</strong></p>
  
  <p>I need to convert a timestamp to Day-of-week name.</p>
  
  <p>e.g. convert today's timestamp (2016-11-24 00:00:00) into a string: 'Thursday'</p>
  
  <p>Thanks :)</p>