POWER

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-POWER--(--expression-1--,--expression-2--)------------------><
 

The POWER function returns the result of raising the first argument to the power of the second argument. 48

expression-1
The argument must be an expression that returns a value of any built-in numeric, character-string, or graphic-string data type. A string argument is cast to double-precision floating point before evaluating the function. For more information on converting strings to double-precision floating point, see DOUBLE_PRECISION or DOUBLE.
expression-2
The argument must be an expression that returns a value of any built-in numeric data type. If the value of expression-1 is equal to zero, then expression-2 must be greater than or equal to zero. If the value of expression-1 is less than zero, then expression-2 must be an integer value.

The result of the function is a double-precision floating-point number. If both arguments are 0, the result is 1. If an argument can be null, the result can be null; if an argument is null, the result is the null value.

Example


48.
The result of the POWER function is exactly the same as the result of exponentiation: expression-1 ** expression-2.