โฑ๏ธ Unix Timestamp Converter
Convert between Unix time and human-readable dates
What is Unix Timestamp?
A Unix timestamp (also called Epoch time or POSIX time) is the number of seconds that have elapsed since January 1, 1970, 00:00:00 UTC. It's a universal way to represent time in computing.
Unix timestamps are used in databases, APIs, log files, and programming. They're timezone-independent, making them ideal for storing and comparing times across different systems.
Note: Some systems use milliseconds (13 digits) instead of seconds (10 digits). This converter automatically detects and handles both formats.
Frequently Asked Questions
What is the current Unix timestamp?
The current Unix timestamp is shown at the top of this page and updates in real-time. It represents the number of seconds since January 1, 1970 (UTC).
Why is my timestamp 13 digits instead of 10?
A 13-digit timestamp is in milliseconds, while a 10-digit timestamp is in seconds. JavaScript's Date.now() returns milliseconds. This converter handles both automatically.
What is the Unix Epoch?
The Unix Epoch is January 1, 1970, 00:00:00 UTC. All Unix timestamps are measured as seconds (or milliseconds) since this moment. It was chosen as a convenient reference point.
How do I convert a timestamp in Excel?
In Excel, use: =(A1/86400)+DATE(1970,1,1) for seconds, or =(A1/86400000)+DATE(1970,1,1) for milliseconds. This converts to Excel's date format.
What happens in 2038?
The Year 2038 problem: 32-bit systems storing timestamps as signed integers will overflow on January 19, 2038. Most modern systems use 64-bit integers, solving this until the year 292 billion.
Are Unix timestamps timezone-dependent?
No! Unix timestamps are always in UTC. When you convert to a human-readable date, you apply a timezone. This makes timestamps perfect for international applications.
How do I get the current timestamp in code?
JavaScript: Date.now() (ms) or Math.floor(Date.now()/1000) (s). Python: import time; time.time(). PHP: time(). Java: System.currentTimeMillis()/1000.
What is ISO 8601 format?
ISO 8601 is an international standard for date/time representation: YYYY-MM-DDTHH:MM:SSZ. The "T" separates date and time, "Z" indicates UTC. Example: 2026-02-02T12:00:00Z.