Question: how to calculate age in years months and days in sql server?
Answer: Declare@dateofbirthdatetime.
Declare@currentdatetimedatetime.
Declare@yearsvarchar(40)
Declare@monthsvarchar(30)
Declare@daysvarchar(30)
set@dateofbirth='1986-03-15'--birthdate.
set@currentdatetime =getdate()--current datetime.
select@years=datediff(year,@dateofbirth,@currentdatetime)-- To find Years.