DECLARE @DateDiff INT =DATEDIFF(DAY,'2024-03-31',GETDATE()) SELECT CAST(@DateDiff/365.25 AS INT) AS NoYear,CAST((@DateDiff%365)/30.5 AS INT) AS NoMONTH ,CAST(((@DateDiff%365)%30.5) AS INT) AS NoDaysDATEDIFF (datepart, start, end) Select *, DATEDIFF(year, DOB,GETDATE()) as COLUMN_NAME from TABLE_NAME GETDATE = CURRENT DATE DOB = PATIENT'S DATA OF BIRTH YEAR = FORMAT THAT WILL RETURN THE PATIENT AGE FOR EXAMPLE: 21 (IF YOU PUT MONTH INSTEAD OF YEAR , IT WILL GIVE YOU THE AGE IN MONTHS, LIKEWISE FOR DAY) FOR EXAMPLE: YEAR = 21, MONTH = 252, DAY = 7665