LN or LOG

The LN and LOG functions return the natural logarithm (base e) of the specified number.

Syntax

LN ( number )
LOG ( number )

number

A  DOUBLE PRECISION number that is greater than zero (0).

Example

splice> VALUES( LOG(84.4), LN(84.4) );
1                  |2
--------------------------------------
4.435674016019115  |4.435674016019115

1 row selected

Results

The data type of the returned value is a  DOUBLE PRECISION number.

  • If the specified number is NULL, the result of these functions is NULL.
  • If the specified number is zero or a negative number, an exception is returned that indicates that the value is out of range (SQL state 22003).

See Also