Archives of the TeradataForum

Message Posted: Fri, 06 May 2011 @ 12:58:07 GMT

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

One consideration might be the use of 'powers' with TD. E.g. select 2**1000 as B10PWR; is the std. raise to a power of base 10.

TD will also support:

raising the base of natural logarithms (e) to the power of the argument,

          SELECT EXP (2) AS BePWR;

computing the natural logarithm of the argument,

          SELECT LN (7.38905609893065E 000) as LNPWR; and

computing the base 10 logarithm of an argument.

          SELECT Log (20) AS B10LOG;

I did not research how you would implement these for your case, but the issue of the precision could possibly be resolved, as the results above can run to hundreds of numeric positions; probably not the most precise description.

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