LOG10

Returns the log base 10 of the numeric input expression.

Syntax

LOG10(expression DOUBLE) → DOUBLE

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

Examples

LOG10 example

SELECT LOG10(20.5)
-- 1.3117538610557542

LOG10(expression int64) → DOUBLE

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

Examples

LOG10 example

SELECT LOG10(100)
-- 2.0

LOG10(expression int32) → DOUBLE

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

Examples

LOG10 example

SELECT LOG10(100)
-- 2.0

LOG10(expression float) → DOUBLE

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

Examples

LOG10 example

SELECT LOG10(20.5)
-- 1.3117538610557542