Outdated Version
You are viewing an older version of this section. View current production version.
LOG2
Returns the logarithm of the given argument to base 2.
Syntax
LOG2 ( number )
Arguments
- number: the number to take the logarithm of.
Info
log2(n) is equivalent to log(n) / log(2).
Return Type
Float or double. If number is less than or equal to 0, or if base is non-positive or 1, returns NULL.
Examples
select log2(16);
+----------+
| log2(16) |
+----------+
| 4 |
+----------+