Toggle navigation
Log in
Sign Up
Log in
Sign Up
Appium
C
C#
C++
Docker
Go
Informatica
Java
JavaScript
Kafka
Numpy
Oracle
Pandas
PHP
Py Spark
Python
R
React Native
Scipy
SFTP
Tableau
Teradata
TGMC
UNIX
Introducing
Radical.sh
Forget Code launches a powerful code generator for building API's
Forget_Code.Models.CategoryViewModel
Add a new snippet
Aggregate Functions
8
BTEQ
76
Collect Statistics
5
CTE
2
Cursor
3
Data Type
3
Date Functions
27
DCL Queries
4
DDL Queries
46
DML Queries
6
Error And Resolution
2
Functions
3
Loaders
3
Macro
6
Math Functions
14
Misc
15
Query Tuning
3
Select Modifiers
56
Snippets
13
String Functions
9
Choose Category
EXP - Exponentiation in Teradata
Forget Code
Teradata
EXP - Exponentiation
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.
Tags for EXP - Exponentiation in Teradata
exponentiation in teradata
DP_Math Functions
teradata exponent
teradata exponential
teradata exponentiation
Teradata SQL EXP function
exponentials in teradata
exponential on Teradata syntax
exponential in teradta sql
Contribute to Forget Code, help others.
Add snippet