Translations:Faq/Base/121/6/de
SELECT "Geburtsdatum",
(HSQLDB, GUI)
CASE
WHEN( DAYOFYEAR("Geburtsdatum") > DAYOFYEAR(CURRENT_DATE))
THEN DATEDIFF('yy',"Geburtsdatum",CURRENT_DATE)-1
ELSE DATEDIFF('yy',"Geburtsdatum",CURRENT_DATE)
END
AS "Alter"
FROM "Person"