Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Best Way to Calculate Age

    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) >=...

Viewing post 1 (of 1 total)