- 类别:
:doc:`/sql-reference/functions-numeric`(指数和根)
CBRT¶
返回数值表达式的立方根。
语法¶
CBRT( <input_expr> )
Returns¶
If the input expression is of type DECFLOAT, the returned type is DECFLOAT. Otherwise, the returned type is FLOAT.
示例¶
SELECT x, CBRT(x) FROM tab;
--------+-------------+
x | cbrt(x) |
--------+-------------+
0 | 0 |
2 | 1.25992105 |
-10 | -2.15443469 |
[NULL] | [NULL] |
--------+-------------+