Mysql Query Example to calculate Age

Posted: May 16, 2011 in computer, Tecnhology and IETE, Knowledge Base

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;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s