SQL LN() function
SQL LN() function returns the natural logarithm of n, where n is greater than 0 and its base is a number equal to approximately 2.71828183.
DB2, PostgreSQL, and Oracle
All of above platforms support the SQL syntax of LN().
MySQL and SQL Server
If you are using above two platforms, use LOG() instead.
|expression||An expression which is a float or can be converted to a float.|
SQL LN() function: Pictorial presentation
To get the natural logarithm of 65 from the DUAL table, the following SQL statement can be used:
SELECT LN(65) "natural_log of 65" FROM dual;
natural_log of 65 ----------------- 4.17438727
Note: Outputs of the said SQL statement shown here is taken by using Oracle Database 10g Express Edition.
Here is a slide presentation which covers the SQL arithmetic functions.
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join