EXP - Exponentiation in Teradata

EXP is a Teradata extension to the ANSI SQL-99 standard. It will raise the e to the power of the input supplied.
The main advantage of this function is to get exponential value of the input argument. e satisfies the logic of the base of algorithms and having the value 2.71828182845905.

Functionality: e^(input)

General Syntax
SELECT EXP(float fNumber)


Teradata expects the input as float otherwise it will convert internally by the rules. It will throw error if it cannot convert to float value (i.e. CHAR)

The below code will yield the result 1.00000000000000E+000

SELECT EXP(0)



The below code will yield the result 2.71828182845905E+000
SELECT EXP(1)


You can use the above codes with SELECT statements for columns for which you want to calculate.