log10.md

description
Returns the log base 10 of the numeric input expression.

LOG10

Syntax

LOG10(expression DOUBLE) → DOUBLE

• expression: The value for which you want to calculate the log.

Examples

{% code title="LOG10 example" %}

SELECT LOG10(20.5)
-- 1.3117538610557542

{% endcode %}

LOG10(expression int64) → DOUBLE

• expression: The value for which you want to calculate the log.

Examples

{% code title="LOG10 example" %}

SELECT LOG10(100)
-- 2.0

{% endcode %}

LOG10(expression int32) → DOUBLE

• expression: The value for which you want to calculate the log.

Examples

{% code title="LOG10 example" %}

SELECT LOG10(100)
-- 2.0

{% endcode %}

LOG10(expression float) → DOUBLE

• expression: The value for which you want to calculate the log.

Examples

{% code title="LOG10 example" %}

SELECT LOG10(20.5)
-- 1.3117538610557542

{% endcode %}