EXP function - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

EXP function

The EXP function implements the exponential function for a numeric expression, or the base of the natural logarithm, e, raised to the power of expression. The EXP function is the inverse of LN function.





The expression must be an INTEGER, DECIMAL, or DOUBLE PRECISION data type.

Return type



The following example uses the TICKIT sample database. For more information, see Sample database.

Use the EXP function to forecast ticket sales based on a continuous growth pattern. In this example, the subquery returns the number of tickets sold in 2008. That result is multiplied by the result of the EXP function, which specifies a continuous growth rate of 7% over 10 years.

SELECT (SELECT SUM(qtysold) FROM sales, date WHERE sales.dateid=date.dateid AND year=2008) * EXP((7::FLOAT/100)*10) qty2018; +-------------------+ | qty2018 | +-------------------+ | 695447.4837722216 | +-------------------+