Power() mvSQL database function in Jitterbit App Builder¶

Summary¶

Calculates the value of a number to the power of another number

Syntax¶

POWER(<value>, <exponent>)

Parameters¶

value¶

The value to apply the exponent to

exponent¶

The value of the exponent

Returns¶

numeric value¶

The type matches the type of the value passed in

Remarks¶

Supports negative exponents as well.

Examples¶

POWER(3,2)

Returns 9

POWER(3,-2)

Returns .111