LN - Firebolt Documentation

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:

SELECT LN(1.0);

ln double
0

Rows: 1Execution time: 5.63ms

The following example returns the natural logarithm close to e:

SELECT LN(2.7182818284590452353);

ln double
1

Rows: 1Execution time: 5.00ms

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

SELECT LN(0.0);
-- SELECT LN(-1.0);
-- SELECT LN('-Inf');

| | | |

Rows: 0Execution time: 0.65ms

IS_INFINITE

LOG

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

LN

Syntax

Parameters

Return Type

Examples

​Syntax

​Parameters

​Return Type

​Examples

Syntax

Parameters

Return Type

Examples