Collections:
EXP() - Exponential Based on E
How to calculate the natural exponential of a given number using the EXP() function?
✍: FYIcenter.com
EXP(X) is a MySQL built-in function that calculates the natural exponential of a given number. For example:
SELECT EXP(-1.0), EXP(0.0), EXP(1.0); -- +---------------------+----------+-------------------+ -- | EXP(-1.0) | EXP(0.0) | EXP(1.0) | -- +---------------------+----------+-------------------+ -- | 0.36787944117144233 | 1 | 2.718281828459045 | -- +---------------------+----------+-------------------+
Reference information of the EXP() function:
EXP(X): val Returns the value of e (the base of natural logarithms) raised to the power of X. The inverse of this function is LOG() (using a single argument only) or LN(). Arguments, return value and availability: X: Required. The input value. val: Return value. The natural exponential of X. Available since MySQL 4.0.
Related MySQL functions:
⇒ EXPORT_SET() - Exporting Binary Set to On/Off Flags
⇐ FORMAT_BYTES() - Formatting Bytes in Readable Units
2023-11-14, 414🔥, 0💬
Popular Posts:
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...