`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.

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

Example

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

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

natlLogExample
3.0