CBRT

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 result is correctly rounded: the DOUBLE PRECISION value closest to the exact cube root, the same on every platform. The cube root of an exact cube is exact.

The following example returns the cube root of 27:

SELECT CBRT(27.0);

cbrt double
3

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