QA Toolbox logoQA Toolbox

Unix Timestamp to Date

Turn a Unix timestamp into a readable date.

About Unix Timestamp to Date

Unix Timestamp to Date turns a raw epoch value from a log line, database row or API response back into a readable date — shown as ISO 8601, UTC and your local time side by side. The unit (seconds vs. milliseconds) is auto-detected from the magnitude, or you can force it.

Seeing UTC and local time together prevents the most common misreading: an event that happened at 23:50 UTC yesterday is "today" locally, and half of all timestamp confusion in bug triage is exactly this.

How to use

  1. Paste the timestamp into "Unix timestamp".
  2. Leave "Unit" on auto-detect, or force seconds/milliseconds if your value is unusual.
  3. Click "Convert to date" and read the ISO 8601, UTC and local renderings.
  4. "Now" inserts the current timestamp if you want a reference point.

Frequently asked questions

How does auto-detect know seconds from milliseconds?

By magnitude: values of 1e12 and above are treated as milliseconds (13 digits, dates after 2001), smaller ones as seconds. Recent timestamps detect correctly; for far-past or far-future values, set the unit explicitly.

Why does the date look one day off?

Almost certainly the time zone: near midnight UTC, local time falls on a neighboring day. Compare the UTC and local lines in the output — the instant is the same, only the calendar label differs.

What are negative timestamps?

Instants before January 1, 1970 UTC — Unix time simply counts negative. They are valid and this converter handles them; whether your application does is worth a test.

Related tools