title: Adding colon after two numbers using Standard SQL
body: <p>I'm trying to run a query in Big-Query using standard SQL.</p>
  
  <p>I have a column in my table where time is presented in this format: <strong>170519</strong></p>
  
  <p>What I want to do is to add colon <strong>(:)</strong> after every two numbers to get results like this: <strong>17:05:19</strong></p>
  
  <p>How do i do this?</p>
  
  <p>I have been searching but have not been able to find a solution to this. Maybe I'm not searching with the correct words?</p>
  
  <p>Thanks for the help!</p>
  
  <p><strong><em>EDIT:</em></strong></p>
  
  <p>So @Gordon Linoff 's answer works for one column.</p>
  
  <p>Now how do I use that in when combining two columns?</p>
  
  <p>Here is my code where I get a syntax  Error:</p>
  
  <pre><code>SELECT
    CONCAT(FORMAT_DATE("%Y-%m-%d", PARSE_DATE('%d%m%Y',
          Date1)), '  ',(PARSE_TIME("%H%M%S",
          Time1)) AS Date_Time
    FROM
  </code></pre>