Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Calculate age - Most easiest way

    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...

  • RE: Calculate age - Most easiest way

    I've always liked this to get the age in years

    select cast(datediff(d,@dob,getdate())/365.25 as int)

Viewing 2 posts - 1 through 2 (of 2 total)