MINUTE

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;

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;

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;