ln function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns the natural logarithm (base e) of expr.

Syntax 

ln(expr)

Arguments

  • expr: An expression that evaluates to a numeric.

Returns

A DOUBLE.

if the argument is out of bounds, the result is NULL.

Examples 

> SELECT ln(1);
 0.0