Topic
1 reply Latest Post - ‏2012-05-21T12:27:44Z by dickr
SystemAdmin
SystemAdmin
5837 Posts
ACCEPTED ANSWER

Pinned topic Using decimal data type to work with monetary values

‏2012-05-06T12:42:21Z |
Hi,

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?
Thanks,
Davis
Updated on 2012-05-21T12:27:44Z at 2012-05-21T12:27:44Z by dickr
  • dickr
    dickr
    31 Posts
    ACCEPTED ANSWER

    Re: Using decimal data type to work with monetary values

    ‏2012-05-21T12:27:44Z  in response to SystemAdmin
    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.