Returns the value of a base number raised to the specified power.

Syntax

---

POWER(<NumericExpression> TO <IntegerExpression>)
POWER(<NumericExpression>, <IntegerExpression>)

<NumericExpression> =

Type of:

SMALLINT
INTEGER|INT
BIGINT
FLOAT
DECIMAL|NUMERIC

<IntegerExpression> =

Type of:

SMALLINT
INTEGER|INT
BIGINT

Returns

---

FLOAT

Usage

---

The POWER function returns value of a base number raised to the specified power.

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: