LN
Description
Returns the natural logarithm of x to base e.
Alias
- DLOG1
Syntax
LN(<x>)Parameters
| Parameter | Description |
|---|---|
<x> | Antilogarithm should be greater than 0 |
Return value
Return a float-point number. Special cases:
- If x IS NULL, return NULL
Example
select ln(1);+-----------------------+
| ln(cast(1 as DOUBLE)) |
+-----------------------+
| 0.0 |
+-----------------------+select ln(e());+---------+
| ln(e()) |
+---------+
| 1.0 |
+---------+select ln(10);+------------------------+
| ln(cast(10 as DOUBLE)) |
+------------------------+
| 2.302585092994046 |
+------------------------+