> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference material for CBRT function

# CBRT

Returns the cube root of a numeric value.

## Syntax

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
CBRT(<value>)
```

## Parameters

| Parameter | Description                              | Supported input types                                                          |
| :-------- | :--------------------------------------- | :----------------------------------------------------------------------------- |
| `<value>` | The value whose cube root is calculated. | `DOUBLE PRECISION` (implicit cast from `INTEGER`, `BIGINT`, `REAL`, `NUMERIC`) |

## Return Type

`DOUBLE PRECISION`

## Remarks

* `CBRT(NULL)` returns `NULL`.
* `CBRT('NaN')` returns `NaN`.
* `CBRT('Infinity')` returns `Infinity` and `CBRT('-Infinity')` returns `-Infinity`.
* Unlike `SQRT`, `CBRT` accepts negative inputs and returns a negative result.

## Example

The following example returns the cube root of 27:

<div className="query-window">
  ```
  SELECT CBRT(27.0);
  ```

  | cbrt <span>double</span> |
  | :----------------------- |
  | 3.0000000000000004       |

  <p><span>Rows: 1</span><span>Execution time: 2.05ms</span></p>
</div>

The following example shows that `CBRT` accepts negative values:

<div className="query-window">
  ```
  SELECT CBRT(-8.0);
  ```

  | cbrt <span>double</span> |
  | :----------------------- |
  | -2                       |

  <p><span>Rows: 1</span><span>Execution time: 2.33ms</span></p>
</div>