POWER function

The POWER numeric function raises a value to the power supplied.

Syntax

Read syntax diagramSkip visual syntax diagramPOWER(ValueNumericExpression ,PowerNumericExpression)

POWER returns the given value raised to the given power. The parameters can be any built-in numeric data type. The result is FLOAT unless any parameter is NULL, in which case the result is NULL

An exception occurs, if the value is either:
  • Zero and the power is negative, or
  • Negative and the power is not an integer