Archives of the TeradataForum
Message Posted: Thu, 16 May 2002 @ 17:55:08 GMT
| Subj: || || Re: Rounding in Teradata |
| From: || || Calvin W. Kline, jr. |
I believe that Teradata decimal rounding and Teradata binary rounding works as designed.
The main "problem" is the exact decimal (base 10) fractions are repeating fractions when represented in the binary system (base 2). And
the binary representation does not round in the same way as the decimal representation. And when the rounded binary number is converted to
decimal for display, confusion results.