Archives of the TeradataForum

Message Posted: Thu, 16 May 2002 @ 15:54:58 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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

Matthew Lipke

	<Prev	Next>		<<First	<Prev	Next>	Last>>