LN - Natural log in Teradata


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

..