Link Search Menu Expand Document

LOG

Returns the common (base 10) logarithm of a numerical expression, or the logarithm to an arbitrary base if specified as the first argument.

Syntax

LOG([<value>,] <exponent>);

Parameters

Parameter Description Supported input types
<value> Optional. The base for the logarithm. The default base is 10. DOUBLE PRECISION
<exponent> The exponent for the logarithm. DOUBLE PRECISION

Return Type

DOUBLE PRECISION

Example

This example below returns the logarithm of 64.0 to base 2:

SELECT
    LOG(2, 64.0);

Returns: 6

This example below returns the logarithm of 100.0 to the default base 10:

SELECT
    LOG(100.0);

Returns: 2