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

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 (optional): The base to use.
  • expression: The value for which you want to calculate the log.

Examples

LOG example 
SELECT LOG(20.5, 1.5)
-- 0.1342410830900514

LOG([base_expression double], expression double) → double​

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

Examples

LOG example 
SELECT LOG(20.5, 1.5)
-- 0.1342410830900514

LOG(expression int64) → double​

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

Examples

LOG example 
SELECT LOG(10)
-- 2.302585092994046

LOG([base_expression int64], expression int64) → double​

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

Examples

LOG example 
SELECT LOG(10, 2)
-- 0.30102999566398114

LOG(expression int32) → double​

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

Examples

LOG example 
SELECT LOG(10)
-- 2.302585092994046

LOG([base_expression int32], expression int32) → double​

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

Examples

LOG example 
SELECT LOG(10, 2)
-- 0.30102999566398114

LOG(expression float) → double​

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

Examples

LOG example 
SELECT LOG(12.5)
-- 2.5257286443082556

LOG(expression double) → double​

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

Examples

LOG example 
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.