CBRT
All functions > MATH > CBRT
Returns the cube root of a number.
Syntax
CBRT(number: T) → DOUBLEsql
Type Parameters:
T: Any numeric type (TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL)
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
number | T | Yes | The number to find the cube root of |
Returns
DOUBLE - The cube root of the input
Notes
- The cube root of a negative number is negative
CBRT(x³) = xfor any real number x- Returns NULL if the input is NULL
- More numerically stable than
POW(x, 1.0/3.0)for negative numbers