Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Numbers with higher precision
From:   Leslie, Quincy

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023