EXP Function

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

Category: Mathematical
Returned data type: DOUBLE

Syntax

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>
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

See Also

Last updated: February 23, 2017