LOG in Teradata

  1. Forget Code
  2. Teradata
  3. LOG

LOG computes the base 10 logarithm of an argument and it is a Teradata extension to the ANSI SQL-99 standard.

Syntax: 
SELECT LOG(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 LOG(50)

Result:1.69897000433602E


 SELECT LOG(100)

Result: 2

..