Archives of the TeradataForum

Message Posted: Tue, 10 Nov 2009 @ 13:47:12 GMT

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

If you start with a decimal (or float) and want a numeric result, casting to character and back is inefficient. Arithmetic is better. For two decimal places:

     my_decimal MOD 1.00

or, if you want the result to look like an integer,

     cast(my_decimal MOD 1.00 * 100 as integer)

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