Answers for "calculating age from date of birth in mysql"

mysql calculate age

SELECT DATEDIFF(CURRENT_DATE, STR_TO_DATE(t.birthday, '%d-%m-%Y'))/365 AS ageInYears
  FROM YOUR_TABLE t

Posted by: Guest on April-26-2020

mysql get age from date

SELECT YEAR(CURRENT_DATE)-YEAR(t.birthday) AS ageInYears
  FROM YOUR_TABLE t

Posted by: Guest on August-30-2021

Code answers related to "calculating age from date of birth in mysql"