Products Downloads


French version


 

 

Mobile DBMS version: this function is not permitted with DB2 or Oracle.

 

Syntax

POWER_OF(Argument1,Argument2)

 

Description

The POWER_OF SQL scalar function returns the result of raising the first argument to the power of the second argument.

 

Both arguments must be numbers.

 

The result of the function is a double-precision floating-point number.

If an argument can be null, the result can be null; if an argument is null, the result is the null value.

 

Example

Assume the column HPOWER is an integer with value 3.

 

POWER_OF(2,HPOWER)

 

Returns the value 8.

 

List of SQL scalar functions by topic

 

↑ Top of page


  • Aucune étiquette