Archives of the TeradataForum

Message Posted: Wed, 25 Oct 2006 @ 19:55:36 GMT

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

I am looking for a UDF which is similar to Oracle round() function. I do not want to turn RoundHalfwayMagUp to TRUE in DBSControl but instead would like to allow certain groups of users use the round UDF for their data rounding needs.

Anyone aware of this ?

................................................................

In Teradata

     select cast(0.25 as decimal(15,1)) = 0.2

     select cast(0.26 as decimal(15,1)) = 0.3

In Oracle

     select round(0.25,1) from dual = 0.3

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