Power Function

Wed, 03/04/2009 - 20:02 |  hdanzl


Syntax

<power function> ::=


Notes

♦ The POWER function returns the value of the first argument raised to the power of the second argument.
♦ If both arguments are 0, then the result is 1.
♦ If the first argument is 0 and the second argument is positive, then the result is 0.
♦ If the first argument is negative, then the second argument shall be an exact numeric value with scale 0.
♦ The data type of the result is DOUBLE PRECISION.
♦ If either of the arguments are null, then the result is null.


Examples

Expression

Result

POWER( 0, 0 )

1

POWER( 0, 3 )

0

POWER( -2, 3 )

-8

POWER( 2, 3 )

8


Conformance

SQL:2003 standard

-

Feature T621 "Enhanced numeric functions"
‹ Exponential FunctionupSquare Root Function ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Functions | Numeric Value Functions

Powered by Drupal and Drupal Theme created with Artisteer.