Pow

The Pow() function calculates a number to the power of another number.

The operator ^ can also be used to do power-calculation.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a number. Returns Invalid expression if one of the parameter values is not a valid number, and returns unknown if one of the parameters is unknown.

Syntax

Pow(number, power)

Pow(10, 3) => 1000

Pow() => Invalid expression

Parameters

Name	Type	Required	Description
number	numeric	☑️	a number
power	numeric	☑️	a number

Examples

Function call	Result
Pow(1, 0)	1
Pow(0, 1)	0
Pow(2, 3)	8
Pow(0.5, -0.5)	1.4142135624
Pow(-0.5, 0.5)	NaN (not a number)
Pow(1234, 1234)	infinity