TIMESTAMP_DIFF

1
SELECT
2
  request_id,
3
  request_time,
4
  response_time,
5
  TIMESTAMP_DIFF(response_time, request_time, MILLISECOND) as latency_ms
6
FROM `project.dataset.api_logs`;

1
SELECT
2
  session_id,
3
  TIMESTAMP_DIFF(session_end, session_start, SECOND) as duration_seconds,
4
  TIMESTAMP_DIFF(session_end, session_start, MINUTE) as duration_minutes
5
FROM `project.dataset.sessions`;

1
SELECT
2
  user_id,
3
  AVG(TIMESTAMP_DIFF(event_time, LAG(event_time) OVER (PARTITION BY user_id ORDER BY event_time), SECOND)) as avg_time_between_events
4
FROM `project.dataset.events`
5
GROUP BY user_id;