Calculating Age in Years, Months and Days in SQL Server 2012

this code works... http://www.itdeveloperzone.com/2011/06/date-difference-in-years-months-and.html

your code ignores the age of an infant. If you need the correct age, down to the day - look at the solution in Mamadou Doumbia's comment.

Here is my code, it also works fine:********************************************* CREATE FUNCTION fnCalculAge(@DOB Datetime) RETURNS nvarchar(50) AS BEGIN DECLARE @tempdate datetime, @years int,@months int, @days int SELECT @tempdate = @DOB SELECT @years = DATEDIFF(YEAR, @tempdate, GETDATE())- CASE WHEN (MONTH(@DOB) > MONTH(GETDATE())) OR (MONTH(@DOB) = MONTH(GETDATE()) AND DAY(@DOB) > DAY(GETDATE())) THEN 1 ELSE 0 END SELECT @tempdate = DATEADD(YEAR,@years,@tempdate) SELECT @months = DATEDIFF(MONTH,@tempdate,GETDATE()) - CASE WHEN DAY(@DOB) > DAY(GETDATE()) THEN 1 ELSE 0 END SELECT @tempdate= DATEADD(MONTH,@months, @tempdate) SELECT @days = DATEDIFF(DAY,@tempdate,GETDATE()) DECLARE @Age nvarchar(60) Set @Age = CAST(@years as nvarchar(4)) + ' years ' + CAST(@months as nvarchar(2)) + ' months and ' + CAST( @days as nvarchar(2)) + ' days.' return @Age END Use like this "SELECT dbo.fnCalculAge ('DOB')--DOB in datetime format. Thanks.

useful article..

Good article, but not working for some case

Thanks Baji Sankar.

Good article,,,