SECOND

1
SELECT
2
  event_time,
3
  HOUR(event_time) as hour,
4
  MINUTE(event_time) as minute,
5
  SECOND(event_time) as second
6
FROM (
7
  SELECT TIMESTAMP '2024-06-15 14:30:45' as event_time UNION ALL
8
  SELECT TIMESTAMP '2024-06-15 09:15:30' UNION ALL
9
  SELECT TIMESTAMP '2024-06-15 23:59:59'
10
);

1
SELECT
2
  event_time,
3
  LPAD(HOUR(event_time)::VARCHAR, 2, '0') || ':' ||
4
  LPAD(MINUTE(event_time)::VARCHAR, 2, '0') || ':' ||
5
  LPAD(SECOND(event_time)::VARCHAR, 2, '0') as formatted_time
6
FROM events;

1
SELECT
2
  event_time,
3
  HOUR(event_time) * 3600 +
4
  MINUTE(event_time) * 60 +
5
  SECOND(event_time) as seconds_since_midnight
6
FROM events;