CBRT

All functions > MATH > CBRT

Returns the cube root of a number.

Signatures

Returns: The cube root of the input

CBRT(number: T) → DOUBLE

Notes

• The cube root of a negative number is negative
• CBRT(x³) = x for any real number x
• Returns NULL if the input is NULL
• More numerically stable than POW(x, 1.0/3.0) for negative numbers

Examples

SELECT
    f1 := CBRT(8.0e0),  -- Positive cube root
    f2 := CBRT(27.0e0),  -- Perfect cube
    f3 := CBRT(-8.0e0),  -- Negative cube root
    f4 := CBRT(1.0e0),  -- Cube root of one
    f5 := CBRT(0.0e0)  -- Cube root of zero
;