Math

LOG10

MySQL

Menghitung logaritma basis 10 dari angka. Setara dengan LOG(10, x).

Tipe hasil: DOUBLEDiperbarui: 7 Jan 2026

Syntax

SQL

LOG10(x)

xnumericwajib

Angka yang akan dihitung log basis 10 (> 0)

SQL

1 SELECT LOG10(1000) AS log_1000;

Log basis 10 dari 1000.

Hasil

log_1000: 3

SQL

1 SELECT value,
2   FLOOR(LOG10(ABS(value))) AS magnitude
3 FROM measurements
4 WHERE value > 0;

Menentukan orde magnitudo.

Hasil

(order of magnitude)

SQL

1 SELECT power_watts,
2   10 * LOG10(power_watts / 0.001) AS power_dbm
3 FROM signals;

Konversi power ke decibel.

Hasil

(power in dBm)

1	SELECT value,
2	FLOOR(LOG10(ABS(value))) AS magnitude
3	FROM measurements
4	WHERE value > 0;