Archives of the TeradataForum

Message Posted: Mon, 09 Nov 2009 @ 10:53:48 GMT

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

Hope this workaround will help you though not a direct function.

     SELECT 1234.56 AS nbr
          , CAST(nbr - (CAST(nbr AS BIGINT)) AS DECIMAL(10,2)) AS mantissa

Thanks & Regards,

Murali D.

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