Altes Datum jjmmtt umrechnen in jjjjmmtt

[richter]

Hallo,

danke - ja so geht es:
CASE WHEN
CAST(SUBSTR(DIGITS(DATUMOLD), 1, 2) as INTEGER) <=99 AND
CAST(SUBSTR(DIGITS(DATUMOLD), 1, 2) as INTEGER) >50 THEN
CAST(SUBSTR(DIGITS(DATUMOLD), 1, 2) as INTEGER) +1900
ELSE
CAST(SUBSTR(DIGITS(DATUMOLD), 1, 2) as INTEGER) + 2000
End AS Jahr