Translations:Faq/Base/121/6/de

    From The Document Foundation Wiki

    SELECT "Geburtsdatum",
    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"
    (HSQLDB, GUI)