Reference Guide > TDV Support for SQL Functions > TDV-Supported Numeric Functions > POWER
 
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