CBRT
描述
计算参数的立方根
语法
cbrt(<a>)
参数
| 参数 | 说明 |
|---|---|
<a> | 浮点参数 |
返回值
参数 <a> 的立方根,浮点数。
特殊情况
- 当
a为NaN,返回NaN - 当
a为正无穷,返回Infinity - 当
a为负无穷,返回-Infinity - 当
a为NULL,返回NULL
举例
select cbrt(0);
+-------------------------+
| cbrt(cast(0 as DOUBLE)) |
+-------------------------+
| 0.0 |
+-------------------------+
select cbrt(-111);
+----------------------------+
| cbrt(cast(-111 as DOUBLE)) |
+----------------------------+
| -4.805895533705333 |
+----------------------------+
select cbrt(1234);
+----------------------------+
| cbrt(cast(1234 as DOUBLE)) |
+----------------------------+
| 10.726014668827325 |
+----------------------------+
select cbrt(cast('nan' as double));
+------------------------------+
| cbrt(cast('nan' AS DOUBLE)) |
+------------------------------+
| NaN |
+------------------------------+
select cbrt(cast('inf' as double));
+------------------------------+
| cbrt(cast('inf' AS DOUBLE)) |
+------------------------------+
| Infinity |
+------------------------------+
select cbrt(cast('-inf' as double));
+-------------------------------+
| cbrt(cast('-inf' AS DOUBLE)) |
+-------------------------------+
| -Infinity |
+-------------------------------+