Answers for "how to calculate age range in mysql"

SQL
0

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
-1

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 "SQL"

Browse Popular Code Answers by Language