Products Downloads


French version


 

 

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

 

Syntax

EXPONENTIAL(Argument)

 

Description

The EXPONENTIAL SQL scalar function returns a value that is the base of the natural logarithm (e) raised to the power specified by the argument.

The EXPONENTIAL and LOGARITHM_N functions are inverse operations.

 

The argument must be a number.

 

The data type of the result is double-precision floating point.

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

 

Example

Assume the column E is a decimal (10,9) column with a value of 3.453789832.

 

EXPONENTIAL(E)

 

Returns the approximate value 31.62.

 

List of SQL scalar functions by topic

 

↑ Top of page


  • Aucune étiquette