CBRT - Firebolt Documentation

Returns the cube root of a numeric value.

Syntax

CBRT(<value>)

Parameter	Description	Supported input types
`<value>`	The value whose cube root is calculated.	`DOUBLE PRECISION` (implicit cast from `INTEGER`, `BIGINT`, `REAL`, `NUMERIC`)

DOUBLE PRECISION

CBRT(NULL) returns NULL.
CBRT('NaN') returns NaN.
CBRT('Infinity') returns Infinity and CBRT('-Infinity') returns -Infinity.
Unlike SQRT, CBRT accepts negative inputs and returns a negative result.

The following example returns the cube root of 27:

SELECT CBRT(27.0);

cbrt double
3.0000000000000004

Rows: 1Execution time: 2.05ms

The following example shows that CBRT accepts negative values:

SELECT CBRT(-8.0);

cbrt double
-2

Rows: 1Execution time: 2.33ms

⌘I