Johan van de Merwe
8 years
Johan van de Merwe
8 years

Select age in mysql between 2 dates

Posted . Visible to the public.

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
Johan van de Merwe
Last edit
Johan van de Merwe
Tags