3 ms·
SUBTRACT BirthYear FROM CurrentYear GIVING Age Isn't that off-by-one, for half the year (on average)?
by rikkus 13y ago
SUBTRACT BirthYear FROM CurrentYear GIVING Age
Isn't that off-by-one, for half the year (on average)?
- nyrina 13y agoI would guess not, seeing as it's BirthYear and not BirthDate
- sacado2 13y agoYes, it is.
- deleted 13y ago[deleted]
- delinka 13y agoIf you're born on January 1, you get the right answer all year long. If you're born on December 31, you get a new value on New Year's day and it'll be wrong all year. EDIT: After re-reading you, yes, it's off-by-one for someone in the population for half the year on average.