Math

LN

PostgreSQL

Menghitung natural logarithm (log base e) dari number. Number harus positif. Kebalikan dari EXP.

Tipe hasil: double precision

Syntax

SQL

LN(number)

numbernumericwajib

Angka positif yang akan dihitung ln-nya

SQL

1 SELECT LN(1), LN(2.71828), LN(10);

ln(1)=0, ln(e)≈1, ln(10)≈2.3

Hasil

ln	ln	ln
0	0.99999932734728	2.30258509299405

SQL

1 SELECT 
2   LN(end_value / start_value) / years AS annual_growth_rate
3 FROM (
4   SELECT 1000 AS start_value, 1500 AS end_value, 5 AS years
5 ) t;

Menghitung continuous growth rate.

Hasil

annual_growth_rate
0.0810930216216329

MySQL

Snowflake

BigQuery

DuckDB

1	SELECT
2	LN(end_value / start_value) / years AS annual_growth_rate
3	FROM (
4	SELECT 1000 AS start_value, 1500 AS end_value, 5 AS years
5	) t;