CBRT

説明

パラメータの立方根を計算します

構文

CBRT(<a>)

パラメータ

Parameter	デスクリプション
<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                     |
+-------------------------------+