ln function
The ln function returns the natural logarithmic value (base e) of the specified expression.
Syntax:
double ln(n)Semantics:
- n: The argument n is an expression that resolves to a number.
- return type: double.
- Returns a NULL value in the following cases:
- n resolves to a NULL value
- n does not resolve to a number
- Returns NaN in the following cases:
- n resolves to NaN
- n is less than zero
- Returns positive infinity if n resolves to positive infinity.
- Returns negative infinity if n is positive/negative zero.
- Returns a NULL value in the following cases:
Example 12-82 ln function
SELECT ln(n) FROM PHtable| Value of n | Output |
|---|---|
| 1 | 0.0 |
| 10 | 2.302585092994046 |
| 1.0E-7 | -16.11809565095832 |