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)