title: DB2 For i: Convert Char YYMMDD to Date
body: <p>I have a CHAR_Date column containing date values in the format 'YYMMDD'. </p>
  
  <p>I would like to do date arithmetic so I need to convert it into a Date data type. The problem is that the Char_Date also contains Blanks.</p>
  
  <p>How do I cast the CHAR_Date to a DATE_Date column, with valid values?</p>