POWER

The POWER function returns the value of the first input argument raised to the power indicated by the second input argument.

Syntax

POWER (value, exponent) 

Remarks

The table lists the valid input argument data types and the resulting output data types.

Data Type of Value	Data Type of Exponent	Output Type
BIGINT, DECIMAL, FLOAT, INTEGER, NUMERIC, REAL, SMALLINT, TINYINT	BIGINT, DECIMAL, FLOAT, INTEGER, NUMERIC, REAL, SMALLINT, TINYINT	FLOAT
NULL	BIGINT, DECIMAL, FLOAT, INTEGER, NUMERIC, REAL, SMALLINT, TINYINT	NULL
BIGINT, DECIMAL, FLOAT, INTEGER, NUMERIC, REAL, SMALLINT, TINYINT	NULL	NULL