log({m},{n})

Returns the natural logarithm (base m) of a number n. The values m and n can be any positive, non-zero numeric value in the range 0 < m, n <= 1.797e308 and m ≠ 1.

log({m}{n}) takes the following syntax.

SELECT log(baseNumber, numericValue) as AliasName
FROM dataset;

Example

This example returns the base 2 logarithm for the number 8.

SELECT log(2.0,8.0) as natlLogExample FROM Superstore
LIMIT 1;