Calculate Age in SQL Server

Please Pass your date of birth in "DD/MM/YYYY" format and get age .....


Create a Procedure...


create Proc dbo.CalculateAge_ravi  
(@date1 varchar(15))
as
DECLARE @date datetime, @tmpdate datetime, @years int, @months int, @days int
SELECT @date = CONVERT(datetime,@date1,103)

SELECT @tmpdate = @date

SELECT @years = DATEDIFF(yy, @tmpdate, GETDATE()) - CASE WHEN (MONTH(@date) > MONTH(GETDATE())) OR (MONTH(@date) = MONTH(GETDATE()) AND DAY(@date) > DAY(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




Get Your Age

 exec CalculateAge_ravi  'Pass your DOB'