# LOG¶

Returns the natural logarithm value of a numeric expression

The natural logarithm is also known as ln or logarithm to the base of the mathematical constant e.

## Syntax¶

LOG( expr )


## Arguments¶

Parameter Description
expr Positive numeric expression

## Returns¶

Always returns a floating point result.

## Notes¶

• If the input value is NULL, the result is NULL.

## Examples¶

### Natural log values¶

numbers=> SELECT LOG(0.0001), LOG(1), LOG(2.718281), LOG(5000000000000000);
log     | log0 | log1 | log2
--------+------+------+--------
-9.2103 |    0 |    1 | 36.1482