Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
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 |
+----------+
