How to display the exact age in Year Month Day format in SQL Server - Stack Overflow
DECLARE @date datetime, @tmpdate datetime, @years int, @months int, @days int SELECT @date = '06/02/1947' SELECT @tmpdate = @date SELECT @years = DATEDIFF(yy, @tmpdate, GETDATE()) - CASE WHEN (MONTH(@date) > MONTH(GETDATE ......