POW

Returns a number <value> raised to the specified power <value>.

Alias: POWER

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