This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.
CBRT
Returns the cubic-root of a non-negative numeric expression.
Syntax
CBRT(<value>);
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<value> | Value that the CBRT function is applied to | DOUBLE_PRECISION |
Return Type
DOUBLE_PRECISION
Example
The following example returns the cubic-root of 8:
SELECT
CBRT(8);
Returns: 2