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'
0 comments:
Post a Comment