I need to get "Tenure" of employees based on startDate and EndDate
In my attached select it returns whole months.
start 2011-06-27 and end 2011-12-14 would be 5 whole months but 6 is returned
start 2008-06-12 and end 2009-03-26 correctly returns 9 months
Select @temure = datediff(mm,u.employmentStart,IsNull(u.employmentEnd,getdate()))