EXP Function

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

Category: Mathematical
Returned data type: DOUBLE
Syntax
Arguments
Details
Comparisons
Example
See Also

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

Functions:
E Function
LOG Function
Copyright © SAS Institute Inc. All rights reserved.