On this page

    Categories: Math

    LOG

    Returns the logarithm of the numeric input expression. If no base is specified, the natural log (ln) will be calculated.

    Syntax

    LOG(base_expression float, expression float) → double

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

    Examples

    SELECT LOG(20.5, 1.5)
    -- 0.1342410830900514
    

    LOG(base_expression double, expression double) → double

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

    Examples

    SELECT LOG(20.5, 1.5)
    -- 0.1342410830900514
    

    LOG(expression int64) → double

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

    Examples

    SELECT LOG(10)
    -- 2.302585092994046
    

    LOG(base_expression int64, expression int64) → double

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

    Examples

    SELECT LOG(10, 2)
    -- 0.30102999566398114
    

    LOG(expression int32) → double

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

    Examples

    SELECT LOG(10)
    -- 2.302585092994046
    

    LOG(base_expression int32, expression int32) → double

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

    Examples

    SELECT LOG(10, 2)
    -- 0.30102999566398114
    

    LOG(expression float) → double

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

    Examples

    SELECT LOG(12.5)
    -- 2.5257286443082556
    

    LOG(expression double) → double

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

    Examples

    SELECT LOG(12.5)
    -- 2.5257286443082556
    

    Usage Notes

    If base_expression is 1. If base_expression expression is less than 0, NaN will be returned. If the expression input is 0, -Infinity is returned. If the expression input is less than 0, NaN will be returned.