DECLARE @myBirthday DATETIME
SET @myBirthday = '19620707'
SELECT DATEDIFF(yy, @myBirthday, GETDATE()) myAge