LN

Returns natural (base e) logarithm of a numerical expression. The value for which ln is computed needs to be larger than 0, otherwise an error is returned. You can use the function LOG if you want to provide a different base.

Syntax 

LN(<value>);

Parameters

Parameter Description Supported input types
<value> The value for which to compute the natural logarithm. DOUBLE PRECISION

Return Type

DOUBLE PRECISION

Examples

The following example computes the natural logarithm of 1.0:

Interactive SQL Playground 🔥 
SELECT LN(1.0);

The following example returns the natural logarithm close to e:

Interactive SQL Playground 🔥 
SELECT LN(2.7182818284590452353);

The natural logarithm can only be computed for values that are larger than 0. All the following functions return an error:

Interactive SQL Playground 🔥 
SELECT LN(0.0);
-- SELECT LN(-1.0);
-- SELECT LN('-Inf');