By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table mytable(datecolumn varchar(20));
insert into mytable values('CAH132242F0A');
select makedate( concat('20' ,substring(datecolumn,4,2)),substring(datecolumn,6,Length(datecolumn)-(position('F' in datecolumn))+1)) date
from mytable
| date |
|---|
| 2013-08-12 |