EXP Function

Returns the value of the e constant raised to a specified power.

Category:	Mathematical
Returned data type:	DOUBLE

Syntax

Syntax

EXP(expression)

Arguments

expression

specifies any valid SQL expression that evaluates to a numeric value.

Data type	BIGINT, DOUBLE, FLOAT, INTEGER, REAL, SMALLINT, TINTYINT
See	<sql-expression>
See	FedSQL Expressions

Details

The EXP function raises the constant e, which is approximately given by 2.71828, to the power that is supplied by the argument. The result is limited by the maximum value of a double decimal value on the computer.

Comparisons

The EXP function takes an argument and raises e to the power that is supplied by the argument. The E function takes no argument and returns the value 2.7182818.

Example

The following statements illustrate the EXP function:

Statements	Results
select exp(1.0);	2.718282
select exp(0);	1

EXP Function

Syntax

Arguments

expression

Details

Comparisons

Example

See Also