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 |
+----------+