Partial hours rounding

Question

User-954169400 posted

When I enter 3.5 for hours it saves the duration as 4. 

I have changed the database field to a precision of 2

and commented out this section in App_Code/BLL/TimeEntry.cs

//if (duration <= DefaultValues.GetDurationMinValue())
//  throw (new ArgumentOutOfRangeException("duration"));

I'm not sure where the rounding is occuring.  Does anyone know how to stop this?

Thanks,

Answer 1

User197322208 posted

do you have some code ?

Answer 2

User-954169400 posted

I found the problem.  I needed to change the precision of the stored procedures from decimal(18,0) to decimal (18,2)