Viewing post 1 (of 1 total)
Third solution is incorrect, I like my solution the best
declare @DateOfBirth as datetime
set @DateOfBirth = '2/13/1979'
--Incorrect
select DATEDIFF(yy, @DateOfBirth, GETDATE()) - CASE WHEN DATEPART(m, @DateOfBirth) >=...
March 7, 2008 at 9:22 am
#786763