Mysql Query Example to calculate Age in years, months and days:
SELECT CURDATE(),
(YEAR(CURDATE())- YEAR(dob))
- (
RIGHT(CURDATE(),5)<
RIGHT(dob,5)) AS age,
case when ((MONTH(CURDATE())- MONTH(dob))
- (RIGHT(CURDATE(),2)<RIGHT(dob,2)))>0 then ((MONTH(CURDATE())- MONTH(dob))
- (RIGHT(CURDATE(),2)<RIGHT(dob,2))) else ((MONTH(CURDATE())- MONTH(dob))
- (RIGHT(CURDATE(),2)<RIGHT(dob,2))) + 12 end AS Months,
(DAY(CURDATE() – DAY(dob))) AS Days;
Advertisement
