Unix Timestamp — Free Online Converter
A Unix timestamp is the number of seconds elapsed since the Unix epoch on January 1, 1970. This free converter lets you translate any Unix time value to a human-readable date instantly. All processing runs directly in your browser — nothing is ever sent to a server.
Understanding Unix Timestamps
Unix time counts the total number of seconds that have passed since January 1, 1970 at 00:00:00 UTC. This moment — called the Unix epoch — was chosen by the early Unix developers at Bell Labs as a convenient integer baseline near the time the system was being built.
Because Unix time is a single integer anchored to UTC, it is completely timezone-independent. The same value means the same instant everywhere on Earth. This makes it the standard format for storing timestamps in databases, log files, APIs, and distributed systems where nodes may be located in different regions.
Historically, Unix timestamps were stored as 32-bit signed integers. This limits their range to values between -2147483648 and 2147483647. The upper bound corresponds to January 19, 2038 at 03:14:07 UTC. On that date, any software still using a 32-bit timestamp will overflow and wrap to a negative number, rolling back to December 13, 1901 — an issue called the Year 2038 problem (also written Y2K38).
Modern systems have largely moved to 64-bit integers. The Linux kernel adopted the time64_t type in version 5.6 (released 2020), extending the representable range to hundreds of billions of years into the future. Most contemporary programming languages and databases store Unix time as a 64-bit value by default, so Y2K38 is primarily a concern for legacy embedded systems and older software still compiled for 32-bit targets.
Unix Timestamp Reference Table
| Unix Timestamp | UTC Date | Significance |
|---|---|---|
| 0 | Jan 1, 1970 | Unix epoch start |
| 1000000000 | Sep 9, 2001 | One billion seconds |
| 1234567890 | Feb 13, 2009 | 1234567890 milestone |
| 1700000000 | Nov 15, 2023 | Recent reference point |
| 2000000000 | May 18, 2033 | Two billion seconds |
| 2147483647 | Jan 19, 2038 | 32-bit signed max — Y2K38 critical moment |
Current Unix Timestamp
1776195270
Convert
Results
Unix Timestamp in Different Systems
Linux / macOS Terminal
# Get the current Unix timestamp
date +%s
# Convert a Unix timestamp to a human-readable date
date -d @1700000000Windows PowerShell
# Get the current Unix timestamp
[DateTimeOffset]::UtcNow.ToUnixTimeSeconds()
# Convert a Unix timestamp to a readable date
[DateTimeOffset]::FromUnixTimeSeconds(1700000000).UtcDateTimeMySQL
-- Get the current Unix timestamp
SELECT UNIX_TIMESTAMP();
-- Convert a stored Unix timestamp to a readable date
SELECT FROM_UNIXTIME(1700000000);PostgreSQL
-- Get the current Unix epoch seconds
SELECT EXTRACT(EPOCH FROM NOW());
-- Convert a Unix timestamp to a timestamptz
SELECT TO_TIMESTAMP(1700000000);REST APIs
Many REST APIs return Unix timestamps in response bodies or headers. Common fields include created_at, updated_at, and expires_at in epoch seconds. The HTTP Date header uses RFC 2822 format, but X-RateLimit-Reset commonly carries a Unix timestamp in seconds.
// Parse an epoch seconds field from a JSON API response
const createdAt = new Date(response.created_at * 1000).toISOString();Frequently Asked Questions
What is a Unix timestamp?
A Unix timestamp is the count of seconds elapsed since January 1, 1970 00:00:00 UTC. It is timezone-neutral and works universally across all operating systems and programming languages.
Is Unix time in seconds or milliseconds?
Base Unix time is measured in seconds, producing a 10-digit number. JavaScript returns milliseconds via Date.now(), producing a 13-digit number. Always check the digit count to determine the unit before converting.
What is the maximum Unix timestamp?
The maximum value for a 32-bit signed integer is 2147483647, corresponding to January 19, 2038 03:14:07 UTC. After that point, 32-bit systems overflow. 64-bit systems using time64_t can represent dates billions of years into the future.
How do I get Unix time in terminal?
On Linux or macOS run date +%s. To convert a value back use date -d @TIMESTAMP. On Windows PowerShell use [DateTimeOffset]::UtcNow.ToUnixTimeSeconds().
How do I use Unix timestamp in SQL?
In MySQL use UNIX_TIMESTAMP() for the current value and FROM_UNIXTIME(ts) to convert. In PostgreSQL use EXTRACT(EPOCH FROM NOW()) and TO_TIMESTAMP(ts).
Does Unix time account for leap seconds?
No. Unix time assumes every day has exactly 86,400 seconds and ignores leap seconds entirely. This means Unix time can diverge from true UTC by up to approximately 27 seconds due to accumulated leap second adjustments.
Is Unix time UTC or local time?
Unix time is always UTC. Converting to local time is a display-layer concern applied after reading the UTC timestamp. The raw integer value itself always represents seconds elapsed since the UTC epoch.
Related Tools
Unix Timestamp Converter
Convert Unix timestamps to human-readable dates and back, instantly.
Epoch Converter
Convert epoch timestamps to human-readable dates and times.
Timestamp to Date
Convert any Unix timestamp to a readable date and time.
Date to Timestamp
Convert dates and times into Unix timestamps.
Epoch Time
Explore epoch time history, standards, and real-world usage.
UTC Time Now
See the current UTC time live with a real-time clock.
Year 2038 Problem
Learn about the Y2K38 overflow and which systems are affected.
Seconds Since 1970
See how many seconds have elapsed since the Unix epoch.
Epoch Time to Date
Convert epoch time to a readable date with code examples in 6 languages.
Linux Timestamp to Date
Convert Linux/Unix timestamps to readable dates using command-line tools.
Unix Time to Date
Convert Unix time to a readable date with real-world examples and code.