Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Best Way to Calculate Age

    The Third answer should be correct only the CASE condition values are reversed.

    Like this

    "SELECT DATEDIFF(yy, @DateOfBirth, GETDATE()) - CASE WHEN DATEPART(m, @DateOfBirth) >= DATEPART(m, GETDATE()) AND DATEPART(d, @DateOfBirth) >= DATEPART(d,...

Viewing post 1 (of 1 total)