Pow
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.
Syntax
Parameters
Name
Type
Required
Description
number
numeric
☑️
a number
power
numeric
☑️
a number
Examples
Function call
Result
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
Last updated