Translations:Faq/Base/121/5/fr
SELECT "DateNaissance",
CASEWHEN Month(CURRENT_DATE) < month("DateNaissance") or ( Month(CURRENT_DATE) = Month("DateNaissance") and day(CURRENT_DATE) < day("DateNaissance") )
THEN CAST((year(CURRENT_DATE) - year("DateNaissance") -1) AS VARCHAR) || ' ans'
ELSE CAST((year(CURRENT_DATE) - year("DateNaissance") ) AS VARCHAR) || ' ans'END as "Age"from "Table1"