locked
Partial hours rounding RRS feed

  • 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,

    Wednesday, September 1, 2010 9:33 AM

Answers

  • 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)

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, September 1, 2010 3:31 PM

All replies

  • User197322208 posted

    do you have some code ?

    Wednesday, September 1, 2010 2:10 PM
  • 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)

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, September 1, 2010 3:31 PM