POW
Synonym: POWER
Returns a number <value> raised to the specified power <value>.
Syntax
POW(<value>, <exponent>);
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<value> | The base value of the exponent | DOUBLE PRECISION |
<exponent> | The power value of the exponent | DOUBLE PRECISION |
Return Type
DOUBLE PRECISION
Example
The following example calculates 2 to the power of 5:
SELECT
POW(2, 5);
Returns: 32