Solve : Converting character string to date in db2?

1.	Solve : Converting character string to date in db2?
Answer» I have a character STRING that represents CYYMMDD (1100305) and need to convert this to a date for a calculation against another date field. The below CODE where IWNBFY is the field name and 1100305 is the VALUE brings back 3013-07-14 but the ACTUAL date should be 2010-03-05...any help would be appreciated. Thanks!!! SELECT DATE(IWNBFY)

Discussion