Unix timestamps appear in databases, APIs and log files as long numbers like 1767225600. They are easy for computers but unreadable for humans. Here is how to convert them in the tools you already use.
In this guide
- What is Unix time?
- Convert online
- Convert in Excel or Google Sheets
- Convert in code
- Seconds or milliseconds?
What is Unix time?
Unix time counts the seconds since 1 January 1970 00:00:00 UTC (the “epoch”). It ignores time zones, which makes it perfect for storing and comparing dates. For example, 1767225600 is 1 January 2026, 00:00 UTC.
Convert online
Paste the number into our Unix Timestamp to Date converter, or turn a date into a timestamp with Date to Unix Timestamp.
Convert in Excel or Google Sheets
=A1/86400 + DATE(1970,1,1) then format the cell as Date/Time. For millisecond timestamps use =A1/86400000 + DATE(1970,1,1). Add or subtract hours for your time zone (e.g. +6/24 for Bangladesh).
Convert in code
- JavaScript:
new Date(1767225600 * 1000).toISOString() - PHP:
date('Y-m-d H:i:s', 1767225600) - Python:
datetime.fromtimestamp(1767225600, tz=timezone.utc) - MySQL:
FROM_UNIXTIME(1767225600)
Seconds or milliseconds?
10 digits = seconds. 13 digits = milliseconds (common in JavaScript and Java). Divide by 1,000 to convert.
Frequently asked questions
What is the current Unix timestamp?
It increases by one every second; check our converter for live values.
Can Unix time be negative?
Yes, negative values represent dates before 1970.
What happens in 2038?
Signed 32-bit timestamps overflow on 19 January 2038; 64-bit systems are safe.
