DB2 For i: Convert Char YYMMDD to Date
<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>