Unix Timestamp & Epoch Converter
Convert Unix epoch timestamps (seconds & ms) to human-readable dates, UTC, and Excel datetime formats online. Live current epoch clock included.
How to Use Unix Timestamp Converter Online
Follow these quick steps to process your data online directly in your browser with zero latency and 100% privacy.
Example Input & Output
Translates seconds elapsed since January 1, 1970 UTC into structured date and time representations across timezones and programming formats.
1725200000
{
"epochSeconds": 1725200000,
"epochMilliseconds": 1725200000000,
"iso8601": "2024-09-01T14:13:20.000Z",
"utcDate": "Sun, 01 Sep 2024 14:13:20 GMT",
"dayOfWeek": "Sunday"
}Common Use Cases
Database & Log Timestamps
Translate raw integer timestamps from MySQL, PostgreSQL, MongoDB, Redis, or CloudWatch logs into human-readable date strings.
Spreadsheet Conversion (Excel & Sheets)
Convert epoch timestamps in Excel columns using the formula =A1/86400 + DATE(1970,1,1) formatted as DateTime.
API & Webhook Payload Inspection
Verify exp/iat claims in JWT tokens, Stripe webhook events, and OAuth expiration timestamps.
Multi-Language Development
Convert timestamps across JavaScript (new Date(ts * 1000)), Python (datetime.fromtimestamp), Go, PHP, and SQL.
Specifications & Gotchas
Seconds vs. Milliseconds Mismatch
Passing a 10-digit timestamp (seconds) to a function expecting 13-digit milliseconds produces dates in 1970. Multiply seconds by 1000.
Local Timezone vs UTC Confusion
Unix timestamps are strictly timezone-independent and reference UTC. Always check if your application displays local time with DST offset.
Frequently Asked Questions
What is a Unix epoch timestamp?
A Unix timestamp (also known as POSIX time or Epoch time) represents the number of seconds that have elapsed since 00:00:00 UTC on Thursday, 1 January 1970, not counting leap seconds.
How do I convert a Unix timestamp to a date in Excel or Google Sheets?
For Unix timestamps in seconds, use: =A1/86400 + DATE(1970,1,1). For timestamps in milliseconds, use: =A1/86400000 + DATE(1970,1,1). Then format the destination cell as Date or Date/Time.
How do I convert a regular date into a Unix timestamp in Excel?
To convert an Excel date in cell A1 to Unix seconds, use the formula: =(A1 - DATE(1970,1,1)) * 86400.
How do I convert Unix timestamps in JavaScript and Python?
In JavaScript: new Date(timestamp * 1000).toUTCString(). In Python: from datetime import datetime, timezone; datetime.fromtimestamp(timestamp, tz=timezone.utc).
What is the Year 2038 Problem (Y2038)?
On January 19, 2038 at 03:14:07 UTC, 32-bit signed integer timestamps will overflow into negative numbers. Modern 64-bit systems can store timestamps accurately for over 292 billion years.
Related Tools
Date Difference Calculator
Calculate elapsed calendar days, working business days (Mon-Fri), and duration between two dates online with weekend counts and inclusive date options.
Cron Expression Parser
Parse and explain cron expressions in plain English online. Inspect upcoming schedule trigger dates and validate 5-part or 6-part cron syntax.
UUID Generator
Generate secure random UUID v4 and time-sorted UUID v7 identifiers online. Single or bulk UUID generation with hyphen/uppercase options.
JWT Decoder
Decode and inspect JSON Web Tokens (JWT) online. View header, payload claims, expiration timestamps, and signature status in your browser.