Skip to main content

​
Overview

The CBRT() function calculates and returns the cube root of a given number. In mathematical terms, for a number x, its cube root y is determined by the equation y³ = x.

​
Syntax

The syntax for the CBRT() function is as follows: 
CBRT(number)
Where:
  • number: This is a required value representing the number for which you want to calculate the cube root. It can be a positive or negative whole number, a decimal, or even an expression that evaluates to a number.
For example, you can use expressions like SELECT CBRT(some_column) from test_table, assuming some_column contains a numeric value.
Return Value:
- It will return NULL if the argument is NULL.
- It will give an error if you input a parameter that is not a numeric type.

​
Examples

Below are several usage examples of the CBRT() function:

​
Case #1: Basic Cube Root Calculation

Consider the following example: 
  SELECT CBRT(125);
The result of this query will be: 
 cbrt 
------
    5

​
Case #2: Cube Root of a Negative Value

To calculate the cube root of a negative number, use the CBRT() function as shown: 
  SELECT CBRT(-125);
The final result is as follows. 
 cbrt 
------
   -5

​
Case #3: Cube Root of Decimal Result

For calculations with decimal numbers, use the CBRT() function as demonstrated below: 
SELECT CBRT(32);
The result will be a decimal value, as shown below: 
       cbrt        
-------------------
 3.174802103936399

​
Case #4: Cube Root of Decimal Input

In this scenario, fractional seconds are incorporated into the argument: 
SELECT CBRT(0.12815);
The result will be the cube root of the provided decimal value. 
    cbrt    
------------
 0.50416523

​
Case #5: Handling Incorrect Argument

When a non-numeric argument is provided, the CBRT() function works as follows: 
SELECT CBRT('abc');
An error will be generated, and the result will not be valid. 
invalid input syntax for type double precision: "abc"

​
Case #6: CBRT Operator (||/(x))

Here’s an example using the CBRT operator (||/(x)) to calculate the cube root of a given number: 
SELECT ||/(1728) AS cbrt_operator;
In this example, we calculate the cube root of 1728 using the CBRT operator. The result of this query will be: 
   cbrt_operator    
--------------------
 12.000000000000002