Math

LN

MySQL

Menghitung logaritma natural (basis e) dari angka. Kebalikan dari EXP.

Tipe hasil: DOUBLEDiperbarui: 7 Jan 2026

Syntax

SQL

LN(x)

xnumericwajib

Angka yang akan dihitung log naturalnya (> 0)

SQL

1 SELECT LN(EXP(1)) AS one, LN(1) AS zero;

Verifikasi nilai LN.

Hasil

one: 1, zero: 0

SQL

1 SELECT 
2   LN(final_value / initial_value) / years AS annual_growth_rate
3 FROM investments;

Menghitung tingkat pertumbuhan kontinyu.

Hasil

(continuous growth rate)

SQL

1 SELECT growth_rate,
2   LN(2) / growth_rate AS doubling_time
3 FROM growth_data;

Waktu untuk nilai berlipat ganda.

Hasil

(time to double)

1	SELECT
2	LN(final_value / initial_value) / years AS annual_growth_rate
3	FROM investments;

1	SELECT growth_rate,
2	LN(2) / growth_rate AS doubling_time
3	FROM growth_data;