On this page

    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