title: DB2 Convert from YYYYMMDD to Date
body: <p>I have a column that stores a date as char in the format 'YYYYMMDD'. Now I want to convert it to a real date.
  I tried </p>
  
  <pre><code>select cast (DATEFIELD as DATE) as MyDate
  </code></pre>
  
  <p>But it only returns the old <code>YYYYMMDD</code> format labeled as 'DATE'. What am I doing wrong?</p>