Date & Time

HOUR

MySQL

Mengekstrak komponen jam dari nilai waktu atau datetime. Mengembalikan 0-23 untuk waktu normal, bisa lebih besar untuk TIME yang melampaui 24 jam.

Tipe hasil: INTEGERDiperbarui: 7 Jan 2026

Syntax

SQL

HOUR(time)

timetime/datetimewajib

Waktu yang akan diambil jamnya

SQL

1 SELECT HOUR('14:30:00') AS hour;

Mengambil komponen jam.

Hasil

hour: 14

SQL

1 SELECT HOUR(order_time) AS hour,
2   COUNT(*) AS orders
3 FROM orders
4 GROUP BY HOUR(order_time)
5 ORDER BY orders DESC
6 LIMIT 5;

Mencari jam tersibuk untuk pesanan.

Hasil

(peak hours by order count)

SQL

1 SELECT * FROM activities
2 WHERE HOUR(activity_time) BETWEEN 9 AND 17;

Mencari aktivitas dalam jam kerja (9-17).

Hasil

(business hours activities)

HOUR

Snowflake

HOUR

DuckDB

1	SELECT HOUR(order_time) AS hour,
2	COUNT(*) AS orders
3	FROM orders
4	GROUP BY HOUR(order_time)
5	ORDER BY orders DESC
6	LIMIT 5;

1	SELECT * FROM activities
2	WHERE HOUR(activity_time) BETWEEN 9 AND 17;