Skip to main content
Version: Candidate-3.3

cbrt

Description

Computes the cube root of the argument.

This function is supported from v3.3 onwards.

Syntax

DOUBLE cbrt(DOUBLE arg)

Parameters

arg: You can specify only a numeric value. This function converts the numeric value into a DOUBLE value before it computes the cube root of the value.

Return value

Returns a value of the DOUBLE data type. If you specify a non-numeric value, this function returns NULL.

Examples

mysql> select cbrt(8);
+---------+
| cbrt(8) |
+---------+
| 2 |
+---------+

mysql> select cbrt(-8);
+----------+
| cbrt(-8) |
+----------+
| -2 |
+----------+

mysql> select cbrt(0);
+---------+
| cbrt(0) |
+---------+
| 0 |
+---------+

mysql> select cbrt("");
+----------+
| cbrt('') |
+----------+
| NULL |
+----------+

keywords

cbrt, cube root