Unix Timestamp Converter
Convert a Unix (epoch) timestamp to a human-readable date and time, and a date to a timestamp. Works with seconds and milliseconds, shows UTC and your local time zone, and displays the current timestamp live.
Current timestamp
- Seconds
- —
- Milliseconds
- —
Timestamp to date
Detected as seconds
- ISO 8601
- 2025-01-01T00:00:00.000Z
- UTC
- Wednesday, January 1, 2025 at 12:00:00 AM UTC
Date to timestamp
What is a Unix timestamp?
A Unix timestamp, also called epoch time or POSIX time, is the number of seconds elapsed since January 1, 1970 at 00:00:00 UTC. Because it is just a number, with no time zone or date format, it is the most common way to store dates in databases, logs, APIs and JWTs.
Seconds or milliseconds?
Unix systems, PHP, Python and most APIs use seconds (10 digits, such as 1735689600). JavaScript (Date.now()) and Java use milliseconds (13 digits, such as 1735689600000). The tool detects the unit from the number of digits.
How to get the current timestamp
- JavaScript:
Math.floor(Date.now() / 1000) - Python:
int(time.time()) - PHP:
time() - SQL (PostgreSQL):
extract(epoch from now()) - Linux and macOS:
date +%s
The year 2038 problem
Systems that store the timestamp as a signed 32-bit integer can only count up to 2147483647, which is January 19, 2038 at 03:14:07 UTC. After that the number overflows. Modern systems use 64 bits and have no such limit.
Frequently asked questions
What is a Unix timestamp?
It is the number of seconds since January 1, 1970 at 00:00:00 UTC, also called epoch time.
How do I know if a timestamp is in seconds or milliseconds?
By the number of digits. Current dates have 10 digits in seconds and 13 in milliseconds. The tool detects the unit automatically.
Does a Unix timestamp have a time zone?
No. It is always counted in UTC. Time zones only matter when the number is displayed as a date and time.
How do I convert a timestamp to a date in Excel?
Use =A1/86400+DATE(1970,1,1) and format the cell as date and time. The result is in UTC.
What happens in 2038?
Systems that store timestamps as 32-bit integers overflow on January 19, 2038. 64-bit systems, which are the norm today, are not affected.