POWER

 

The function POWER returns the exponential value for the numeric expression.

SQL Syntax:
 
   POWER( number, power )
Number:
 
  Any numeric expression.
Power:
 
  Any numeric expression.
Escape Syntax:
 
  {fn POWER( number, power )}
Return Type:
 
  FLOAT
     

Examples:

  • SELECT POWER(2.0, 3.0), {fn power(3.0, 2.0)}

    Returns: 8.0, 9.0

see also:
SQL Numeric Functions
EXP
LOG
LOG10


100% pure Java DBMS
Mirror Site