Link Search Menu Expand Document

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