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 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.
Last updated
Was this helpful?