10 or 13 digits?
Ten digits means seconds; thirteen means milliseconds.
Turn a Unix timestamp from a log, database or API into a readable date, or get the timestamp for any date and time. Seconds and milliseconds are detected automatically.
Private by design. Conversions use your device's clock and time zone settings. Nothing is uploaded.
A Unix timestamp counts the seconds since 00:00:00 UTC on 1 January 1970, known as the Unix epoch. Because it is a single number with no time zone, it is the most common way computers store and exchange moments in time.
JavaScript and many APIs use milliseconds instead of seconds, which gives a 13-digit number rather than 10 digits. This converter detects which one you pasted. Remember that a timestamp is always UTC; it only becomes a local time when it is displayed for a particular time zone.
Ten digits means seconds; thirteen means milliseconds.
Save timestamps in UTC and convert to local time only for display.
Local times can repeat or skip during clock changes; timestamps do not.
Old 32-bit systems cannot store timestamps after January 2038.
Use =(A1/86400)+DATE(1970,1,1) for seconds, then format the cell as a date. The result is UTC.
No. Unix timestamps are always UTC. This tool shows both UTC and your local time.
Yes. Negative values are dates before 1970.
Yes. Large numbers are automatically read as milliseconds.
Hire dedicated developers from iCreativez who work as part of your team.