Skip to main content

Interactive Timestamp Normalization Explorer

See timestamp normalization in action! Use the interactive explorer below to step through 3 stages of converting mixed timestamp formats into standardized ISO 8601 UTC. Watch how consistent timestamps enable time-based queries and aggregations.

How to Use This Explorer​

  1. Navigate using arrow keys (← →) or click the numbered stage buttons
  2. Compare the Input (left) and Output (right) showing normalization at each stage
  3. Observe how different formats get unified
  4. Inspect the YAML code showing the parsing and conversion logic
  5. Learn from the stage description explaining the benefits

Interactive Timestamp Normalization Explorer​

Mixed Timestamp Formats

IoT devices, APIs, and logs use different timestamp formats (ISO 8601, Unix epoch, RFC 3339, custom). This breaks time-based queries, corrupts aggregations, and causes timezone confusion.

Use ← → arrow keys to navigate
📥Input
{"event":"login","time":"2024-01-15T10:30:00Z"}
{"event":"purchase","time":1705317000}
{"event":"logout","time":"15/01/2024 10:30"}
📤Output
❌ Query Failures:
Cannot sort by time (mixed types)
Time-range filters fail
Aggregation by hour broken
Added/Changed
Removed
Completed Step
Current Step
Not Done Yet
📄New Pipeline Stepstep-0-mixed-formats.yaml
# No timestamp normalization

Try It Yourself​

Next: Set up your environment to build timestamp normalization pipelines