Skip to main content
Version: current [25.0.x]

LOG10

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

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