title: How to change a column from string to date in Amazon Redshift?
body: <p>Beginner here, have searched high and low for this answer but it doesn't work in Amazon Redshift's SQL.</p>
  <p>I have a date column with YYYYMM format, etc 202101 = January 2021. I want to convert it to date format like 2021-01 or 01/2021, whichever is fine but date format. It is best if I can add a column and not replace the original column. But most answers talks about table, but I am using a view.</p>
  <pre><code>select CONVERT(DATA_PERIOD , '01')  FROM view 
  LIMIT 10
  </code></pre>
  <p>SAMPLE DATA for DATA_PERIOD</p>
  <pre><code>DATA_PERIOD
  202101
  202101
  202102
  202102
  202103
  </code></pre>
  <p>Would appreciate some help here, and if there is a way to know Redshift SQL syntax is closest to which language</p>