Archives of the TeradataForum
Message Posted: Thu, 16 May 2002 @ 15:54:58 GMT
Why does Teradata round numbers the way it does? Is there a "real world" application of this type of rounding?
For those that are confused by this line of questioning, I am trying to round decimal fields from hundredths to tenths and for the odd tenths place values they are rounding up and the even tenths place values are rounding down. For example, .15 rounds to .2, .25 rounds to .2, .35 rounds to .4, .45 rounds to .4, etc.
And, what is the SQL to round a .15 to .2 and a .25 to .3?
Thank you for any information you can provide.
FYI, we are running Teradata V2R4.1
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|