Calculate Age in Years, Months and Days from Date of Birth

Easily you can get Age from date of birth using SQL query as below:

DECLARE @date datetime, @tmpdate datetime, @years int, @months int, @days int SELECT @date = '10/25/1981' SELECT @tmpdate = @date SELECT @years = DATEDIFF(yy, @tmpdate, GETDATE()) - CASE WHEN MONTH(@date) > MONTH(GETDATE()) THEN 1 ELSE 0 END SELECT @tmpdate = DATEADD(yy, @years, @tmpdate) SELECT @months = DATEDIFF(m, @tmpdate, GETDATE()) - CASE WHEN DAY(@date) > DAY(GETDATE()) THEN 1 ELSE 0 END SELECT @tmpdate = DATEADD(m, @months, @tmpdate) SELECT @days = DATEDIFF(d, @tmpdate, GETDATE())SELECT @years AS Years, @months AS Months, @days as Days