HOUR

1
SELECT
2
  event_time,
3
  HOUR(event_time) as hour,
4
  MINUTE(event_time) as minute
5
FROM events;

1
SELECT
2
  HOUR(transaction_time) as hour,
3
  COUNT(*) as transaction_count,
4
  SUM(amount) as total_amount
5
FROM transactions
6
WHERE transaction_date = TODAY()
7
GROUP BY HOUR(transaction_time)
8
ORDER BY transaction_count DESC
9
LIMIT 5;

1
SELECT
2
  CASE
3
    WHEN HOUR(login_time) BETWEEN 6 AND 11 THEN 'Morning'
4
    WHEN HOUR(login_time) BETWEEN 12 AND 17 THEN 'Afternoon'
5
    WHEN HOUR(login_time) BETWEEN 18 AND 21 THEN 'Evening'
6
    ELSE 'Night'
7
  END as time_of_day,
8
  COUNT(*) as login_count
9
FROM user_logins
10
GROUP BY time_of_day;