title: STRING to DATE in BIGQUERY
body: <p>I am struggling to try to do this with Google BigQuery:</p>
  <p>I do have a column with dates in the following STRING format:</p>
  <pre><code>6/9/2017   (M/D/YYYY)
  </code></pre>
  <p>I am wondering how can I deal with this, trying to use the DATE clause., in order to get the DATE format:</p>
  <p>YYYY-MM-DD.</p>
  <p>Thanks in advance.</p>