LOG
Returns the common (base 10) logarithm of a numerical expression, or the logarithm to an arbitrary base if specified as the first argument.
Syntax
LOG([<value>,] <exponent>);
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<value> | Optional. The base for the logarithm. The default base is 10. | DOUBLE PRECISION |
<exponent> | The exponent for the logarithm. | DOUBLE PRECISION |
Return Type
DOUBLE PRECISION
Example
This example below returns the logarithm of 64.0 to base 2:
SELECT
LOG(2, 64.0);
Returns: 6
This example below returns the logarithm of 100.0 to the default base 10:
SELECT
LOG(100.0);
Returns: 2