LN - Natural log in Teradata

  1. Forget Code
  2. Teradata
  3. LN - Natural log

LN computes the natural logarithm of an argument and it is a Teradata extension to the ANSI SQL-99 standard.

Syntax: 
SELECT LN(float)


Note:
If the argument is not FLOAT, it is converted to a FLOAT value, based on implicit type conversion rules.
If the argument cannot be converted, an error is reported to the user.

Examples: 
 SELECT LN(2.71828182845905)

Result:1 


 SELECT LN(0)

Result: Error

..