Convert epoch time to a readable date in any time zone - or any date back to a Unix timestamp. Live current time included.
Last updated:
Seconds, milliseconds, microseconds and nanoseconds are detected from the number of digits.
| Digits (today) | Unit | Used by |
|---|---|---|
| 10 | Seconds | Linux, PHP, Python time.time(), MySQL UNIX_TIMESTAMP |
| 13 | Milliseconds | JavaScript Date.now(), Java, Discord, many APIs |
| 16 | Microseconds | PostgreSQL, Python datetime precision |
| 19 | Nanoseconds | Go time.UnixNano(), InfluxDB |
| Language | Seconds | Milliseconds |
|---|---|---|
| JavaScript | Math.floor(Date.now() / 1000) | Date.now() |
| Python | int(time.time()) | int(time.time() * 1000) |
| Java | Instant.now().getEpochSecond() | System.currentTimeMillis() |
| PHP | time() | floor(microtime(true) * 1000) |
| Go | time.Now().Unix() | time.Now().UnixMilli() |
| C# | DateTimeOffset.UtcNow.ToUnixTimeSeconds() | DateTimeOffset.UtcNow.ToUnixTimeMilliseconds() |
| Bash | date +%s | date +%s%3N |
| MySQL | UNIX_TIMESTAMP() | ROUND(UNIX_TIMESTAMP(NOW(3)) * 1000) |
| PostgreSQL | EXTRACT(EPOCH FROM NOW()) | EXTRACT(EPOCH FROM NOW()) * 1000 |
| Language | Example |
|---|---|
| JavaScript | new Date(1767225600 * 1000).toISOString() |
| Python | datetime.fromtimestamp(1767225600, tz=timezone.utc) |
| Excel / Google Sheets | =A1/86400 + DATE(1970,1,1) |
| SQL (MySQL) | FROM_UNIXTIME(1767225600) |
| Bash (Linux) | date -d @1767225600 |
| Timestamp | Date (UTC) |
|---|---|
| 0 | 1 Jan 1970 - the Unix epoch |
| 1000000000 | 9 Sep 2001 |
| 1767225600 | 1 Jan 2026 |
| 2000000000 | 18 May 2033 |
| 2147483647 | 19 Jan 2038 - the "Year 2038 problem" limit for 32-bit systems |
| Format | Example | Where you see it |
|---|---|---|
| Unix seconds | 1767225600 | Linux, APIs, JWT exp/iat |
| Unix milliseconds | 1767225600000 | JavaScript, Java, Discord |
| ISO 8601 | 2026-01-01T00:00:00Z | JSON APIs, logs, HTML datetime |
| RFC 2822 | Thu, 01 Jan 2026 00:00:00 GMT | Email and HTTP headers |
| SQL DATETIME | 2026-01-01 00:00:00 | MySQL, SQL Server |
| Excel serial | 46023 | Spreadsheets (days since 1900) |
Paste it above. The date appears in UTC, your local time and major time zones. 10 digits are seconds, 13 digits are milliseconds.
It is shown live at the top of this page in seconds and milliseconds.
Paste the timestamp; the table includes India (IST), New York (ET), Chicago, Denver and Los Angeles.
Use Date → timestamp: pick the date, time and time zone, then copy the result.
You probably used a seconds value where milliseconds were expected (or the reverse). Multiply or divide by 1000.
Milliseconds were read as seconds. This tool detects the unit from the number of digits.
32-bit signed timestamps overflow at 2147483647 (19 Jan 2038). Use 64-bit time values.
No. It is always UTC-based; the time zone is applied only when displaying it.