Epoch Converter

Work with epoch values in seconds, milliseconds, microseconds and ticks.

Developer Runs in your browser Shareable link
Epoch values
Converted

Nothing converted yet

Paste one epoch value or a whole column of them. The unit is detected from the magnitude and always reported, so you can override a wrong guess.

Arithmetic

Runs entirely in your browser. Your data isn't uploaded — this page makes no network request with anything you type, which you can verify in your browser's network tab. How this works.

What is the Epoch Converter?

Epoch values arrive in inconsistent units. One service emits seconds, another milliseconds, a Java system produces milliseconds with sub-second precision, and a Go or database export might use microseconds or nanoseconds. Comparing them means normalising first.

This converter is built for that: it detects the unit from the magnitude, converts between all four, handles a whole column of timestamps pasted at once, and does simple date arithmetic so you can answer "what was the epoch 30 days before this?" without a calculator.

How to use it

  1. Paste one epoch value, or a whole column of them, into the input.
  2. Confirm or override the detected unit.
  3. Read the converted table — every unit and every common date format.
  4. Use the arithmetic panel to add or subtract an interval, or Download the batch results as CSV.

Example

One value expressed in every epoch unit.

Input
1788825600123 (milliseconds detected)
Result
seconds       1788825600
milliseconds  1788825600123
microseconds  1788825600123000
nanoseconds   1788825600123000000

Features

  • Seconds, milliseconds, microseconds and nanoseconds
  • Batch conversion of many timestamps at once, with CSV export
  • Date arithmetic: add or subtract seconds, minutes, hours, days and weeks
  • Start and end of day, week, month and year for any epoch
  • Live current epoch in every unit

Frequently asked questions

How is the unit detected?
By magnitude. For dates in the current era, a seconds value has about 10 digits, milliseconds 13, microseconds 16 and nanoseconds 19. The heuristic is shown so you can override it for historical dates.
Can it handle negative epochs?
Yes — negative values are dates before 1970 and are converted normally.
What is the difference between this and the Unix Timestamp Converter?
The timestamp converter is for one value with rich time zone and format output. This one is for unit normalisation, bulk conversion and arithmetic.
Esc

Loading the catalog…