Mathematical functions - logarithmic

These functions all operate on numeric expressions only, and will return an error if used on any other values. See also Mathematical operators.

e()

e() returns the base of the natural logarithm, e.

Syntax:

e()

Returns:

A Float.

Example 1. e()
Query
RETURN e()

The base of the natural logarithm, e, is returned.

Table 1. Result
e()

2.718281828459045

Rows: 1

exp()

exp() returns en, where e is the base of the natural logarithm, and n is the value of the argument expression.

Syntax:

e(expression)

Returns:

A Float.

Arguments:

Name Description

expression

A numeric expression.

Considerations:

exp(null) returns null.

Example 2. exp()
Query
RETURN exp(2)

e to the power of 2 is returned.

Table 2. Result
exp(2)

7.38905609893065

Rows: 1

log()

log() returns the natural logarithm of a number.

Syntax:

log(expression)

Returns:

A Float.

Arguments:

Name Description

expression

A numeric expression.

Considerations:

log(null) returns null.

log(0) returns null.

Example 3. log()
Query
RETURN log(27)

The natural logarithm of 27 is returned.

Table 3. Result
log(27)

3.295836866004329

Rows: 1

log10()

log10() returns the common logarithm (base 10) of a number.

Syntax:

log10(expression)

Returns:

A Float.

Arguments:

Name Description

expression

A numeric expression.

Considerations:

log10(null) returns null.

log10(0) returns null.

Example 4. log10()
Query
RETURN log10(27)

The common logarithm of 27 is returned.

Table 4. Result
log10(27)

1.4313637641589874

Rows: 1

sqrt()

sqrt() returns the square root of a number.

Syntax:

sqrt(expression)

Returns:

A Float.

Arguments:

Name Description

expression

A numeric expression.

Considerations:

sqrt(null) returns null.

sqrt(<any negative number>) returns NaN

Example 5. sqrt()
Query
RETURN sqrt(256)

The square root of 256 is returned.

Table 5. Result
sqrt(256)

16.0

Rows: 1