Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionselect Equipe,Nom, to_days(concat(year(curdate()), '-', month(date_de_naissance), '-', dayofmonth(date_de_naissance))) - to_days(curdate()) as difference from contacts where to_days(concat(year(curdate()), '-', month(date_de_naissance), '-', dayofmonth(date_de_naissance))) - to_days(curdate()) between 0 and 100 order by to_days(concat(year(curdate()), '-', month(date_de_naissance), '-', dayofmonth(date_de_naissance))) - to_days(curdate()) asc