Date conversion - how?

I am trying to convert dates from an ISAM database in the form of "yyyymmdd" into a DATE type column in my relational database using just triggers and stored procedures. The closest thing I found was the TO_DATE function, but it won't accept a numeric month field as part of the string. Is there another approach that I'm not finding in any of the documentation? Thanks in advance for your help.