Redigera

Dela via


EXP (SSIS Expression)

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

Returns the exponent to base e of a numeric expression. The EXP function complements the action of the LN function and is sometimes referred to as the antilogarithm.

Syntax

  
EXP(numeric_expression)  

Arguments

numeric_expression
Is a valid numeric expression.

Result Types

DT_R8

Remarks

The numeric expression is cast to the DT_R8 data type before the exponent is computed. For more information, see Integration Services Data Types.

The return result is always a positive number.

Expression Examples

These examples apply the EXP function to positive and negative values and to zero.

EXP(74)  

Returns 1.373382979540176E+32.

EXP(-27)  

Returns 1.879528816539083E-12.

EXP(0)  

Returns 1.

See Also

LOG (SSIS Expression)
Functions (SSIS Expression)