Math

TRUNCATE

MySQL

Memotong angka ke jumlah desimal tertentu tanpa pembulatan. Berbeda dengan ROUND.

Tipe hasil: DECIMAL/DOUBLEDiperbarui: 7 Jan 2026

Syntax

SQL

TRUNCATE(x, d)

xnumericwajib

Angka yang akan dipotong

dintegerwajib

Jumlah digit desimal (wajib, bisa negatif)

SQL

1 SELECT TRUNCATE(2.999, 0) AS t1, TRUNCATE(2.999, 2) AS t2;

Memotong tanpa pembulatan.

Hasil

t1: 2, t2: 2.99

SQL

1 SELECT ROUND(2.55, 1) AS rounded, TRUNCATE(2.55, 1) AS truncated;

ROUND bulatkan, TRUNCATE potong.

Hasil

rounded: 2.6, truncated: 2.5

SQL

1 SELECT TRUNCATE(12345, -1) AS tens,
2   TRUNCATE(12345, -2) AS hundreds;

Memotong digit dari kanan.

Hasil

tens: 12340, hundreds: 12300

TRUNC

PostgreSQL

TRUNCATE

Snowflake

TRUNC

BigQuery

TRUNC

DuckDB

1	SELECT TRUNCATE(12345, -1) AS tens,
2	TRUNCATE(12345, -2) AS hundreds;