LOG Function

Returns the natural logarithm (base e) of a numeric value expression.

Category:	Mathematical
Returned data type:	DOUBLE

Syntax

LOG(expression)

specifies any valid SQL expression that evaluates to a numeric value.

The following statements illustrate the LOG function:

Statements	Results
select log(1.0);	0
select log(10.0);	2.302585