| Subject | Rounding Problems |
|---|---|
| Author | Marcos Vinicius Dufloth |
| Post date | 2001-05-14T19:34:25Z |
Hi list.
I have a problem with numeric fields and rounding. In database, there is a value stored in a numeric(15,4) field equals to 16.7200. Inside a trigger, when this value is moved to a variable, also numeric(15,4), it turns 16.7199999999989 causing some problems to me. I read that numeric types have exactly N digits of precision. Whi this is happening?
Dufloth.
[Non-text portions of this message have been removed]
I have a problem with numeric fields and rounding. In database, there is a value stored in a numeric(15,4) field equals to 16.7200. Inside a trigger, when this value is moved to a variable, also numeric(15,4), it turns 16.7199999999989 causing some problems to me. I read that numeric types have exactly N digits of precision. Whi this is happening?
Dufloth.
[Non-text portions of this message have been removed]