Translations:Faq/Base/121/6/de

From The Document Foundation Wiki
Jump to: navigation, search

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)