Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

CBRT Function

The CBRT function is a mathematical function that calculates the cube root of a number.

Syntax

Copy
CBRT (number)

Argument

CBRT takes a DOUBLE PRECISION number as an argument.

Return Type

CBRT returns a DOUBLE PRECISION number.

Examples

Calculate the cube root of the commission paid for a given transaction:

Copy
select cbrt(commission) from sales where salesid=10000; cbrt ------------------ 3.03839539048843 (1 row)