Declare @dateofbirth datetime
Declare @currentdatetime datetime
Declare @years varchar (40)
Declare @months varchar (30)
Declare @days varchar (30)
set @dateofbirth='1960-04-07'--birthdate
set @currentdatetime =getdate()--current datetime
select @years=datediff(year,@dateofbirth,@currentdatetime)-- To find Years
select @months=datediff(month,@dateofbirth,@currentdatetime)-(datediff(year,@dateofbirth,@currentdatetime)*12)
-- To Find Months
select @days=datepart(d,@currentdatetime)-datepart(d,@dateofbirth)-- To Find Days
select @years +' years, ' +@months +' months, '+@days +' days' asYearMonthDay
-- Create for Rohatash Kumar