Archives of the TeradataForum

Message Posted: Fri, 06 May 2011 @ 11:40:58 GMT

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

<-- Anonymously Posted: Friday, May 06, 2011 06:20 -->

Hi,

I have a situation where I need to have a very high precision for a number. I need to have at least 20 places after the decimal and 30 places in the real part (before decimal). Teradata's decimal allows only a maximum of 38 digits, so I cannot use it. Float is also rules out since it is not so precise. Any suggestions?

Also, I need to do calculations (like division, mod etc) on this column, so cannot use character.

Thanks

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