MySQL age calculation (based on birthday field)

MySQL age calculation (based on birthday field)

Year (From_days (DateDiff (now (), birthdate))//Get Age Now () current time, accurate to seconds DateDiff (begindate,enddate): Returns the number of days related to two dates. from_ Days: Starting from 0000-00-00, returns a date, based on the number of dates passed in; year (date): Gets the years of the date


[Condition Search age 18 to 30]

$map. = "and Year (From_days (DateDiff (Today (), mbbirthday)) >=18 and year (From_days (DateDiff (now  (), Mbbirthday)) ) <30 ";

Year (Curdate ())-year (Birthday) – (Right (Curdate (), 5) <right (birthday,5)

SELECT now (), Curdate (), Curtime ()

Now ()//2012-10-12 16:25:43     curdate ()//2012-10-12    curtime//16:12:45

Right (Curdate (), 5) Intercept 5 fields

MySQL age calculation (based on birthday field)