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