Date & Time
DuckDB
MINUTE
DuckDBMengekstrak komponen menit dari timestamp. Mengembalikan angka 0-59.
Tipe hasil:
INTEGERDiperbarui: 6 Jan 2026Syntax
SQL
MINUTE(timestamp)Parameter
timestampTIMESTAMP/TIMEwajib
Timestamp atau time yang akan diambil menitnya
Contoh Penggunaan
Mengambil Menit dari Timestamp
SQL
1 SELECT 2 log_time, 3 HOUR(log_time) as hour, 4 MINUTE(log_time) as minute, 5 SECOND(log_time) as second 6 FROM system_logs 7 LIMIT 3;
Mengekstrak komponen waktu lengkap dari log.
Hasil
| log_time | hour | minute | second |
|---|---|---|---|
| 2024-06-15 14:30:45.123 | 14 | 30 | 45 |
| 2024-06-15 14:31:02.456 | 14 | 31 | 2 |
| 2024-06-15 14:35:15.789 | 14 | 35 | 15 |
Grouping per 15 Menit
SQL
1 SELECT 2 HOUR(event_time) as hour, 3 (MINUTE(event_time) / 15) * 15 as minute_bucket, 4 COUNT(*) as event_count 5 FROM events 6 GROUP BY HOUR(event_time), (MINUTE(event_time) / 15) * 15 7 ORDER BY hour, minute_bucket;
Mengelompokkan event per interval 15 menit.
Hasil
| hour | minute_bucket | event_count |
|---|---|---|
| 9 | 0 | 45 |
| 9 | 15 | 52 |
| 9 | 30 | 38 |
| 9 | 45 | 41 |
Analisis Delay
SQL
1 SELECT 2 scheduled_time, 3 actual_time, 4 HOUR(actual_time) * 60 + MINUTE(actual_time) - 5 (HOUR(scheduled_time) * 60 + MINUTE(scheduled_time)) as delay_minutes 6 FROM deliveries 7 WHERE actual_time > scheduled_time;
Menghitung keterlambatan dalam menit.
Hasil
| scheduled_time | actual_time | delay_minutes |
|---|---|---|
| 14:00:00 | 14:25:00 | 25 |
| 15:30:00 | 15:45:00 | 15 |
| 16:00:00 | 16:10:00 | 10 |