Date & Time
MySQL
MINUTE
MySQLMengekstrak komponen menit dari nilai waktu atau datetime. Mengembalikan nilai 0-59.
Tipe hasil:
INTEGERDiperbarui: 7 Jan 2026Syntax
SQL
MINUTE(time)Parameter
timetime/datetimewajib
Waktu yang akan diambil menitnya
Contoh Penggunaan
Ekstrak Menit
SQL
1 SELECT MINUTE('14:30:45') AS min;
Mengambil komponen menit.
Hasil
min: 30
Grup per 15 Menit
SQL
1 SELECT HOUR(timestamp) AS hour, 2 FLOOR(MINUTE(timestamp)/15)*15 AS quarter, 3 COUNT(*) AS events 4 FROM log_events 5 GROUP BY hour, quarter 6 ORDER BY hour, quarter;
Agregasi per 15 menit.
Hasil
(events by 15-minute intervals)
Cek Tepat Jam
SQL
1 SELECT * FROM scheduled_jobs 2 WHERE MINUTE(run_time) = 0;
Mencari job yang dijadwalkan tepat jam.
Hasil
(jobs scheduled on the hour)
