I have a database that has several fields of decimal type to work with monetary values. Now I see that there are some problems using it, like the 9.20 value displays the value 9.19. I need to change all the fields in my database to DECFLOAT or is there a function or other alternative to solve it?
Pinned topic Using decimal data type to work with monetary values
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-05-21T12:27:44Z at 2012-05-21T12:27:44Z by dickr
dickr 060001959C31 Posts
Re: Using decimal data type to work with monetary values2012-05-21T12:27:44ZThis is the accepted answer. This is the accepted answer.Do not understand the question. Have you got rounding errors or are you trying to store 20 decimals? Anyway, try decfloat. Will help either way.