跳到主要内容

LOG2

描述

返回以2为底的x的自然对数。

语法

LOG2(<x>)

参数

参数说明
<x>真数 should be greater than 0

返回值

返回一个浮点数。特殊情况:

  • 当x为NULL时,返回 NULL

举例

select log2(1);
+-------------------------+
| log2(cast(1 as DOUBLE)) |
+-------------------------+
| 0.0 |
+-------------------------+
select log2(2);
+-------------------------+
| log2(cast(2 as DOUBLE)) |
+-------------------------+
| 1.0 |
+-------------------------+
select log2(10);
+--------------------------+
| log2(cast(10 as DOUBLE)) |
+--------------------------+
| 3.3219280948873626 |
+--------------------------+