TOOLTIKI Lovable tool, really free
Date & time Timestamps

Milliseconds to date converter

Value
Reading it as
UTC date and time 2023-11-14T22:13:20Z
Readable Tue, 14 Nov 2023 22:13:20 GMT
Unix seconds 1,700,000,000
Unix milliseconds 1,700,000,000,000
Windows FILETIME 133,444,736,000,000,000
.NET ticks 638,355,968,000,000,000
Excel serial 45,244.925926
Mac HFS+ seconds 3,782,844,800
Note
Local · thirteen digits means milliseconds
Advertisement
320 × 100

Converts a millisecond timestamp — the thirteen-digit kind `Date.now()` returns — into a date, and into every other epoch alongside.

How to use the milliseconds to date converter

1 Paste the value. Every other epoch is shown alongside the date.
2 Change what it is being read as if the number is from a different system.
3 All times are UTC — convert to your own zone separately if you need local time.

JavaScript is the main source of these, and the mismatch with the rest of the world is a constant source of off-by-a-thousand bugs: `Date.now()` gives milliseconds while a database `to_timestamp()`, a Python `time.time()` and most APIs give seconds. Passing one where the other is expected does not error, it just produces a date in 1970 or in the far future, which is why it survives code review. If you are storing timestamps, pick one unit and be explicit in the column name — `created_at_ms` costs nothing and prevents the whole class of bug.

Questions

A choice made in 1995 and never revisited. Almost everything else uses seconds, which is the source of endless off-by-a-thousand bugs.

MDN — Date.now()
Advertisement
300 × 250
Was this tool any good?
INTERNAL SIGNAL ONLY · WE USE IT TO FIND TOOLS WORTH REBUILDING