Categories: Math

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

SELECT LOG10(20.5)
-- 1.3117538610557542

LOG10(expression int64) → double

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

Examples

SELECT LOG10(100)
-- 2.0

LOG10(expression int32) → double

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

Examples

SELECT LOG10(100)
-- 2.0

LOG10(expression float) → double

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

Examples

SELECT LOG10(20.5)
-- 1.3117538610557542