title: Get MONTH NAME from date in BigQuery SQL
body: <p>I'm trying to extract the MONTH NAME from a date in BigQuery, the type is DATE (i.e., 2019-09-19). I tried something like:</p>
  
  <blockquote>
    <p>SELECT PARSE_DATE('%B',CAST(date_start AS string)) FROM table</p>
  </blockquote>
  
  <p>but it doesn't work. I also tried some other stuff from the <a href="https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions" rel="nofollow noreferrer">DATE funcs</a> such as <code>EXTRACT</code> and the <a href="https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions" rel="nofollow noreferrer">DATETIME funcs</a> with no luck. </p>
  
  <p>I know there are some functions like <code>MONTHNAME()</code> in other SQL languages, but they don't work in BQ.</p>
  
  <p>Is there a way to do this that doesn't rely in CASE function?</p>
  
  <p>Thanks.</p>