sorry the 3rd answer is not 100% correct as written

DECLARE @DateOfBirth DATETIME

SET @DateOfBirth='08/xx/1975' --commented out the day just because

SELECT DATEDIFF(yy, @DateOfBirth, GETDATE()) AS [first],

FLOOR(CONVERT(decimal(9, 2), DATEDIFF(d, @DateOfBirth, GETDATE()))...