knallt auch ....

Code:
SELECT dec(coalesce(replace(char( date('0001-01-01') +           
(dec(digits(jjjj), 4, 0)-1) years +                              
(dec(digits(mm), 2, 0)-1) month +                                
(dec(digits(tt), 2, 0)-1) days - 5 days, iso                     
), '-', ''), 0), 8, 0) AS DATUM, jjjj*10000+mm*100+tt from datei