Translations:Faq/Base/121/10/de

From The Document Foundation Wiki
Jump to: navigation, search

oder SELECT "Geburtsdatum",
CASE
WHEN( EXTRACT(MONTH FROM "Geburtsdatum") > EXTRACT(MONTH FROM CURRENT_DATE) OR ( EXTRACT(MONTH FROM "Geburtsdatum") = EXTRACT(MONTH FROM CURRENT_DATE) AND EXTRACT(DAY FROM "Geburtsdatum") > EXTRACT(DAY FROM CURRENT_DATE)))
THEN DATEDIFF(year,"StartDate",CURRENT_DATE)-1
ELSE DATEDIFF(year,"StartDate",CURRENT_DATE)
END AS "Alter"
FROM "Person"
(Firebird, GUI)