Skip to Content

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