Returns the natural logarithm of a number.

Syntax

---

LOG(<NumericExpression>)
LN(<NumericExpression>)

<NumericExpression> =

Type of:

SMALLINT
INTEGER|INT
BIGINT
FLOAT
DECIMAL|NUMERIC

Returns

---

FLOAT

Usage

---

The LOG or LN function returns the natural logarithm of a number.

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: