TOOLTIKI Lovable tool, really free
Date & time Timestamps

Unix timestamp 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 · all times UTC
Advertisement
320 × 100

A Unix timestamp counts seconds since 1 January 1970 UTC. Paste one and you get the date plus the same instant in every other common epoch.

How to use the unix timestamp 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.

Two things trip people up regularly. The first is seconds versus milliseconds: JavaScript works in milliseconds and almost everything else in seconds, so a timestamp that decodes to 1970 is a millisecond value being read as seconds, and one that decodes to the year 55000 is the reverse. A ten-digit number is seconds and a thirteen-digit one is milliseconds — that rule holds for any date between 2001 and 2286. The second is the 2038 problem: a signed 32-bit timestamp overflows on 19 January 2038, and systems still storing time in a 32-bit integer will wrap to 1901. Most modern systems use 64 bits and are fine for about 292 billion years.

Questions

Ten digits is seconds, thirteen is milliseconds, for any date this century. If it decodes to 1970 you have milliseconds being read as seconds.

IEEE — POSIX time
Advertisement
300 × 250
Was this tool any good?
INTERNAL SIGNAL ONLY · WE USE IT TO FIND TOOLS WORTH REBUILDING