Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

LN

Returns the logarithm of the given argument to base e.

Syntax

LN ( number )

Arguments

  • number: the number to take the logarithm of.
Info

log(n) is an alias for ln(n).

ln(n) is equivalent to log(n) / log(e).

Return Type

Float or double. If number is less than or equal to 0, or if base is non-positive or 1, returns NULL.

Examples

select ln(1234);
+--------------------+
| ln(1234)           |
+--------------------+
| 7.1180162044653335 |
+--------------------+