Convert & explain
One box, every timestamp format
Numbers are ranked across twelve epochs; text is matched against ISO 8601, SQL, RFC 2822, hex and more. Whatever it decides, it shows its reasoning.
How the converter reads your input
Paste one value into the box. It can be a plain number, like 1700000000, or a date written as text, like 2024-07-16 18:40 or Tue, 16 Jul 2024. There is no unit to pick first. The page works it out.
A number is tried against every epoch it knows. That covers Unix time in seconds, milliseconds, microseconds and nanoseconds, plus .NET ticks, Windows FILETIME, Chrome time, Apple time, Excel serial dates and Julian days. Each reading is scored on how likely it is: does the date land in a sensible year, does the digit count fit, and how common is the format? The best one comes first, and the rest stay in view so you can pick another.
Text is matched against ISO 8601, RFC 2822, SQL dates, week dates, hex and more. Once the page has an instant, it shows it in every format at once, in your zone and in UTC. It also shows the ISO week, the weekday, and how far that moment is from now.
The maths runs in your browser. The address bar keeps what you typed, so a link to the page opens on the same answer.
Questions people ask
How does it know if my number is seconds or milliseconds?
It counts the digits and checks which reading gives a sane date. Ten digits is seconds for any date near now. Thirteen is milliseconds. If a number could be more than one thing, every reading is listed.
Why is the date different from the one in my database?
Most often it is the time zone. A timestamp names one moment. Your database may show that moment in UTC while this page shows it in your local zone. Check the UTC line to compare like with like.
What is an epoch?
It is the zero point a system counts from. Unix counts from 1 January 1970. Windows FILETIME counts from 1601. Excel counts from the end of 1899. The same moment is a very different number in each.
Can I convert a date back into a timestamp?
Yes. Type the date as text and the page gives you the Unix value in seconds and milliseconds, along with every other epoch, ready to copy.