Example
Convert Log Timestamps into a UTC Incident Timeline
A timestamp conversion example for comparing browser, API, and queue events in the same incident note.
The situation
A failed export appears in three systems. The browser log has an ISO string, the API log has Unix seconds, and the queue log has Unix milliseconds. The team needs one UTC timeline.
Mixed timestamp samples
Browser: 2026-07-18T12:00:00-07:00
API: 1784401320
Queue: 1784401385000
Workflow
- Convert the ISO browser value and note its UTC equivalent.
- Treat the 10-digit API value as Unix seconds.
- Treat the 13-digit queue value as Unix milliseconds.
- Sort all converted UTC times in one incident note.
- Keep original values beside converted values for later audit.
UTC timeline note
2026-07-18 19:00:00 UTC - Browser export started
2026-07-18 19:02:00 UTC - API accepted request
2026-07-18 19:03:05 UTC - Queue job failed
Review checks
- Seconds and milliseconds are handled separately.
- UTC is used for ordering across systems.
- Original timestamps should remain in the incident record.