Translations:Faq/Base/121/7/de
oder
SELECT "Geburtsdatum",
(Firebird, GUI)
CASE
WHEN( EXTRACT(YEARDAY FROM "StartDate") > EXTRACT(YEARDAY FROM CURRENT_DATE))
THEN DATEDIFF(year,"StartDate",CURRENT_DATE)-1
ELSE DATEDIFF(year,"StartDate",CURRENT_DATE)
END AS "Alter"
FROM "Person"