Select age in mysql between 2 dates

Between 2 dates

select 
   latest_date, lowest_date,
   floor(datediff(date(latest_date), date(lowest_date)) / 365)
from your_table

With current date

select 
   birth_date,
   floor(datediff(date(now()), date(birth_date)) / 365)
from your_table
Last update: Tue, 13 Sep 2022 14:32:15