Unix Millisecond Micro-Timestamp Inspector
Paste a raw stack of Unix epoch integers and instantly detect precision, convert to ISO 8601 UTC and local time, and isolate latency variations with per-row delta time analysis.
| # | Raw Epoch Integer | Precision | UTC / ISO 8601 | Local Time | Delta (dt) from Previous |
|---|---|---|---|---|---|
|
▴
Paste epoch integers in Panel 1 to populate the inspection matrix.
|
|||||
The Complete Guide to Unix Epoch Timestamp Precision and Delta Analysis
Whether you are debugging a high-frequency trading log, analyzing server telemetry, tracing a distributed system, or auditing a data pipeline, raw epoch integers are rarely human-readable and almost never carry their own unit label. This inspector solves both problems simultaneously: it detects what unit each integer is in, converts it to a readable date, and then computes the time gap between every consecutive pair of entries so you can spot anomalies without writing a single line of code.
How to Use This Tool
Copy your batch of epoch timestamps from any source: a log file, a database query result, a CSV export, a trading system feed, or a packet capture. Paste one integer per line into the Data Stack Injection panel on the left. The Inspection Matrix fills immediately with no submit button required. Each row shows the raw integer, its auto-detected precision tier, the UTC date in ISO 8601 format, your local browser time, and the delta from the row above. If any delta exceeds your configured warning threshold, it is highlighted in amber so it stands out at a glance. You can also use the Sort Chronologically toggle to re-order an out-of-sequence stack before analyzing deltas.
Why Precision Detection from Integer Length Works
The digit-count method works because each precision tier covers a distinct numeric range for any timestamp in the modern era. Second-precision timestamps from the year 2000 through 2100 all fall between 946,684,800 and 4,102,444,800: exactly 10 digits. Multiply by 1,000 (milliseconds) and you get 13 digits. Multiply by 1,000,000 (microseconds) and you get 16 digits. Multiply by 1,000,000,000 (nanoseconds) and you get 19 digits. These tiers do not overlap for dates between approximately 1970 and 2255, making digit length a reliable precision signal without needing any metadata or schema.
BigInt Safety for Microsecond and Nanosecond Math
JavaScript's standard Number type uses 64-bit IEEE 754 floating-point, which can only represent integers exactly up to 2^53 - 1 (about 9 quadrillion). A microsecond timestamp for today is roughly 1,718,000,000,000,000 (16 digits), which is already within the Number.MAX_SAFE_INTEGER limit, but nanosecond timestamps (19 digits) exceed it and would silently lose precision. This inspector uses JavaScript BigInt for all delta calculations involving 16-digit or 19-digit timestamps, converting to BigInt before subtraction and back to a regular number only after scaling down to a safely representable unit for display.
Reading the Delta Column for Anomaly Detection
The Delta column is where the real diagnostic value lives. In a healthy real-time event stream, the delta between consecutive entries should be small and consistent. A delta that is zero (or near-zero) may indicate duplicate events or a timestamp collision. A delta that is much larger than the average may indicate a dropped event, a processing delay, a clock adjustment, or a gap in the data source. The amber warning highlight makes these outliers immediately visible. The Telemetry panel also shows the global minimum and maximum delta across the entire stack so you can calibrate your threshold appropriately.