Viewing post 1 (of 2 total)
All of them are incorrect. I think the correct age will be:
SELECT DATEDIFF(yy, DateOfBirth, GETDATE()) - CASE WHEN
DATEPART(m, DateOfBirth) < DATEPART(m, GETDATE()) OR (DATEPART(m, DateOfBirth)...
March 12, 2008 at 9:36 am
#788655