Skip to main content
Version: 0.0.1

POWER

Categories: Math

POWER

Returns the result of raising the input value to the specified power.

Syntax​

POWER(numeric_expression double, power double) → double​

  • numeric_expression: The input expression.
  • power: The power to raise the numeric_expression to.

Examples

{{< codeheader "POWER example" >}}

SELECT POWER(5, 2)
-- 25.0

{{< codeheader "POWER example" >}}

SELECT POWER(0.1, 2)
-- 0.010000000000000002

{{< codeheader "POWER example" >}}

SELECT POWER(-2, 2)
-- 4.0

{{< codeheader "POWER example" >}}

SELECT POWER(10, -2)
-- 0.01

Usage Notes​

This function always returns a double even if the parameters are both integers.