Export (0) Print
Expand All

EXP (SSIS Expression)

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.

EXP(numeric_expression)

numeric_expression

Is a valid numeric expression.

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.

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.

Community Additions

ADD
Show:
© 2014 Microsoft