Translations:Faq/Base/121/7/de

    From The Document Foundation Wiki

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