Translations:Faq/Base/121/5/fr

    From The Document Foundation Wiki

    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"