title: PARSE_DATE : Invalid result from parsing function BigQuery/Standard SQL
body: <p>I have the following code in BigQuery (standard SQL):</p>
  
  <pre><code>SAFE_CAST (PARSE_DATE('%Y-%m-%d',JSON_EXTRACT_SCALAR(g.p_dataforanalytics,'$.birthday') ) as string)
  </code></pre>
  
  <p>This fails due to:</p>
  
  <blockquote>
    <p>Invalid result from parsing function</p>
  </blockquote>
  
  <p>The problem is that I have no control of the data I get in <code>g.p_dataforanalytics</code> some of it is pure garbage and not in the right format, sometimes it's not even reasonable value.
  Is there a way to define that if <code>PARSE_DATE()</code> fails it will return NULL and not throw the query out?</p>
  
  <p>Basicly I'm looking for something like a try/catch in any programming language?</p>