Archives of the TeradataForum
Message Posted: Wed, 19 May 2004 @ 09:10:48 GMT
You need to cast your answer to decimal(1,0) to get the rounding you want.
select cast(2.50001 as decimal(10,0))
Unfortunately, Teradata rounds down from 0.5 not from 0.4.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|