I need to calculate age from DOB in one single line. I found the following by searching the web:
(datediff (month, DOBColumn, GETDATE())/12) as age
However, it only works on months and there is subsequently a small margin of error which I can't really live with since this software is for races with age groups. I don't want to create a function/SP.