Viewing 2 posts - 1 through 2 (of 2 total)
Yes there is an issue if the age is under 4 years.
I have used the prior version for adults and it works great, but for handling all birthdays
select cast(datediff(d,@dob,getdate())/case when...
December 2, 2014 at 9:30 am
#1762143
I've always liked this to get the age in years
select cast(datediff(d,@dob,getdate())/365.25 as int)
December 2, 2014 at 5:21 am
#1762006