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 |
|---|---|---|---|
| numeric | a number | |
| 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