PostgreSQL LN() function

Last update on July 29 2024 06:18:59 (UTC/GMT +8 hours)

LN() function

The PostgreSQL LN() function is used to return the natural logarithm of a given number, as specified in the argument. The natural logarithm is the logarithm to the base e, where e is approximately equal to 2.71828.

Uses of LN() Function

Mathematical Calculations: To perform natural logarithmic calculations in mathematical formulas.

Scientific Research: Useful in scientific research and computations involving logarithmic functions.

Financial Analysis: To calculate continuous compounding interest and other financial models requiring natural logarithms.

Data Analysis: In statistical and data analysis where natural logarithms are needed to model data trends and transformations.

Syntax:

ln()

PostgreSQL Version: 9.3

Pictorial presentation of PostgreSQL LN() function

Example: PostgreSQL LN() function:

Code:

SELECT LN(3.0) AS "Natural Logarithm";

Sample Output:

  Natural Logarithm
--------------------
 1.0986122886681097
(1 row)

Previous: FLOOR function
Next: LOG function