Translations:Faq/Base/121/5/fr

From The Document Foundation Wiki
Jump to navigation Jump to search
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"