LOG in Teradata


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

..