Math

FLOOR

DuckDB

Membulatkan angka ke bawah ke bilangan bulat terdekat. Kebalikan dari CEIL.

Tipe hasil: BIGINT atau DOUBLE (tergantung input)Diperbarui: 6 Jan 2026

Syntax

SQL

FLOOR(number)

numbernumericwajib

Angka yang akan dibulatkan ke bawah

SQL

1 SELECT FLOOR(3.2), FLOOR(3.8), FLOOR(-3.2), FLOOR(-3.8);

Membulatkan berbagai angka ke bawah.

Hasil

FLOOR(3.2)	FLOOR(3.8)	FLOOR(-3.2)	FLOOR(-3.8)
3	3	-4	-4

SQL

1 SELECT
2   FLOOR(age / 10) * 10 as age_bucket,
3   COUNT(*) as count
4 FROM users
5 GROUP BY FLOOR(age / 10) * 10
6 ORDER BY age_bucket;

Mengelompokkan user ke bucket umur (20-29, 30-39, dll).

Hasil

SQL

1 SELECT
2   task_name,
3   duration_minutes,
4   FLOOR(duration_minutes / 60) as hours,
5   duration_minutes % 60 as remaining_minutes
6 FROM tasks;

Mengkonversi menit ke jam dan sisa menit.

Hasil

task_name	duration_minutes	hours	remaining_minutes
Task A	150	2	30
Task B	75	1	15

1	SELECT
2	task_name,
3	duration_minutes,
4	FLOOR(duration_minutes / 60) as hours,
5	duration_minutes % 60 as remaining_minutes
6	FROM tasks;