LOG10

描述

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

别名

• DLOG10

语法

LOG10(<x>)

参数

参数	说明
<x>	真数 必须大于0

返回值

返回一个浮点数。

• 当 x IS NULL：返回 NULL

举例

select log10(1);

+--------------------------+
| log10(cast(1 as DOUBLE)) |
+--------------------------+
|                      0.0 |
+--------------------------+

select log10(10);

+---------------------------+
| log10(cast(10 as DOUBLE)) |
+---------------------------+
|                       1.0 |
+---------------------------+

select log10(16);

+---------------------------+
| log10(cast(16 as DOUBLE)) |
+---------------------------+
|        1.2041199826559248 |
+---------------------------+