The Pow() function calculates a number to the power of another number.
The operator ^ can also be used to do power-calculation.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a number.
Returns Invalid expression if one of the parameter values is not a valid number, and returns unknown if one of the parameters is unknown.
| Name | Type | Required | Description |
|---|---|---|---|
| Function call | Result |
|---|---|
number
numeric
a number
power
numeric
a number
Pow(1, 0)
1
Pow(0, 1)
0
Pow(2, 3)
8
Pow(0.5, -0.5)
1.4142135624
Pow(-0.5, 0.5)
NaN (not a number)
Pow(1234, 1234)
infinity