Unix Timestamp to Human Readable Date
A Unix timestamp is the number of seconds (or milliseconds) since the Unix epoch: January 1, 1970, 00:00:00 UTC. This free tool converts any Unix timestamp to human readable date instantly, supporting seconds, milliseconds, and multiple timezones.
What Is a Unix Timestamp?
Also called Unix time, POSIX time, or Epoch time, it is a system for describing a point in time by counting seconds from the epoch. It is the backbone of most operating systems, databases, and programming languages.
| Type | Unit | Example | Human Readable (UTC) |
|---|---|---|---|
| Unix Timestamp (seconds) | 1 sec | 1750000000 | April 4, 2025, 12:26:40 PM |
| Unix Timestamp (milliseconds) | 1/1000 sec | 1750000000000 | April 4, 2025, 12:26:40 PM |
| Unix Timestamp (microseconds) | 1/1,000,000 sec | 1750000000000000 | April 4, 2025, 12:26:40 PM |
How to Convert Unix Timestamp to Human Readable Date
Using This Tool 1. Enter your Unix timestamp (seconds or milliseconds) 2. Select your timezone or use UTC 3. View the human readable date instantly 4. Copy the formatted result
Using Programming Languages | Language | Code | |----------|------| | JavaScript | new Date(timestamp * 1000).toLocaleString() | | Python | datetime.fromtimestamp(timestamp, tz=timezone.utc) | | Java | Instant.ofEpochSecond(timestamp).toString() | | PHP | date(Y-m-d H:i:s, timestamp) | | SQL | FROM_UNIXTIME(timestamp) | | Bash | date -d @timestamp |
Using Online Converters - Search Unix timestamp converter on Google for instant results - Use epochconverter.com for batch processing - Use unixtimestamp.com for timezone conversions
Common Unix Timestamp Examples
| Event | Unix Timestamp (seconds) | Human Readable Date (UTC) |
|---|---|---|
| Unix Epoch Start | 0 | January 1, 1970, 12:00:00 AM |
| Y2K (2000) | 946684800 | January 1, 2000, 12:00:00 AM |
| iPhone Launch | 1194624000 | June 29, 2007, 12:00:00 AM |
| Bitcoin Genesis Block | 1231148866 | January 3, 2009, 6:15:05 PM |
| Current (2026) | 1750000000+ | June 25, 2026 |
Current Unix Timestamp
The current Unix timestamp right now is approximately 1750000000+ seconds or 1750000000000+ milliseconds.
Timezone Conversion Tips
- UTC is the standard reference for Unix timestamps
- EST (UTC-5): Subtract 5 hours from UTC
- PST (UTC-8): Subtract 8 hours from UTC
- IST (UTC+5:30): Add 5 hours 30 minutes to UTC
- JST (UTC+9): Add 9 hours to UTC
- Use your tool below to convert to any timezone instantly
Unix Timestamp to Date in Excel
1. In cell A1, enter your timestamp (seconds) 2. In cell B1, enter formula: =(A1/86400)+25569 (if timestamp is in seconds) 3. Format cell B1 as Date/Time
For milliseconds: =(A1/86400000)+25569
Leap Seconds and Timestamp Accuracy
Unix timestamps do not account for leap seconds. This means:
- Every day has exactly 86400 seconds in Unix time
- Real Earth days vary slightly due to leap seconds
- The difference accumulates slowly and is corrected periodically
- For most applications, this discrepancy is negligible
Converting Human Readable Date Back to Unix Timestamp
| Method | Input | Output |
|---|---|---|
| Online | June 25, 2026, 5:28:38 PM +03:00 | 1750000000+ |
| JavaScript | new Date(2026-06-25T17:28:38+03:00).getTime() / 1000 | 1750000000+ |
| Python | datetime(2026, 6, 25, 17, 28, 38, tzinfo=timezone(timedelta(hours=3))).timestamp() | 1750000000+ |
Troubleshooting
| Issue | Cause | Solution |
|---|---|---|
| Wrong date by 1 hour | DST not applied | Check timezone settings |
| Wrong date by years | Used milliseconds instead of seconds | Divide by 1000 |
| 1970 date | Timestamp is 0 or negative | Check data source |
| Future date | Timestamp too large | Verify input unit |
Conclusion
Use this Unix timestamp to human readable date converter for fast, accurate results. Whether you are a developer debugging logs, a data analyst cleaning datasets, or a curious user checking a date, this tool handles seconds, milliseconds, and timezones effortlessly.
Bookmark this page for quick conversions without installing software.