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

select 
   birth_date,
   floor(datediff(date(now()), date(birth_date)) / 365)
from your_table

Johan van de Merwe

Last edit

2017-01-06

Johan van de Merwe