Skip to main content
Version: Latest-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