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.


CBRT (number)


CBRT takes a DOUBLE PRECISION number as an argument.

Return Type

CBRT returns a DOUBLE PRECISION number.


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

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