RE: ROUND() function doesn't round properly – SQLServerCentral

Dave Ballantyne

SSC-Dedicated

Points: 33667

October 2, 2009 at 4:16 am

Heres how to calculate an age

select CASE

WHEN dateadd(year, datediff (year, d1, d2), d1) > d2

THEN datediff (year, d1, d2) - 1

ELSE datediff (year, d1, d2)

END as Age

I'll take a look at the rounding issue though...

Clear Sky SQL
My Blog[/url]