title: Converting YYYYMMDD string to date in standard SQL / BigQuery
body: <p>I have this column called 'Date' that contains dates formatted this way: '20150101'.</p>
  
  <p>I tried using sql substring, but when I run the query using 'date' function in sql, it doesn't work on the date format I have.</p>
  
  <p>Here is the query I made: </p>
  
  <pre><code>SELECT (DATE ((SUBSTR(JOUR, 1, 4), 
                 SUBSTR(JOUR, 5, 2), 
                 SUBSTR(JOUR, 7, 2)))) As date 
  FROM TABLE
  </code></pre>
  
  <p>Any idea? I couldn't find anything similar to this date format! I found one that uses the convert function but it's not in StandardSQL or BigQuery</p>