Archives of the TeradataForum

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

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.