Date & Time

TIME

MySQL

Mengekstrak bagian waktu dari datetime atau timestamp. Menghapus komponen tanggal.

Tipe hasil: TIMEDiperbarui: 7 Jan 2026

Syntax

SQL

TIME(expr)

exprdatetimewajib

Ekspresi datetime atau timestamp

SQL

1 SELECT TIME('2024-01-15 14:30:45') AS time_only;

Mengambil bagian waktu saja.

Hasil

time_only: 14:30:45

SQL

1 SELECT HOUR(TIME(created_at)) AS hour,
2        COUNT(*) AS order_count
3 FROM orders
4 GROUP BY HOUR(TIME(created_at));

Menghitung order per jam.

Hasil

hour: 14, order_count: 100

1	SELECT HOUR(TIME(created_at)) AS hour,
2	COUNT(*) AS order_count
3	FROM orders
4	GROUP BY HOUR(TIME(created_at));