Timestamp Converter — Unix, Excel, FILETIME, .NET Ticks
Developer time converter: Unix timestamp ↔ date, plus Excel date number, Windows FILETIME and .NET DateTime.Ticks. Auto-detects sec/ms/us/ns, UTC and local time, ISO 8601, live current timestamp.
About the Timestamp Converter
One tool for every popular time epoch: Unix (Linux, JavaScript, Java), Excel date number, Windows FILETIME (NTFS, Active Directory) and .NET DateTime.Ticks. The converter shows the time in UTC and your local zone, produces ISO 8601, and outputs values in every other epoch at once — handy when moving data between systems.
Where you'll need it
Debugging APIs and logs
Time in JSON responses and logs is most often a Unix timestamp. Paste it — see what moment it points to and compare against server or client time.
iat / exp in JWT and Java
JWT iat / exp / nbf are Unix seconds. Java System.currentTimeMillis() and JS Date.now() are milliseconds. The converter detects scale by digit count automatically.
Excel ruined your date
Excel stores dates as days since 1900. If your CSV export shows '45245.5' instead of a date — that's an Excel date number. Pick the Excel epoch and get the proper date.
Windows logs and Active Directory
AD lastLogon, pwdLastSet, NTFS timestamps — all FILETIME, 100-ns since 1601. .NET DateTime.Ticks is the same idea but starting from year 0001. Just paste — see the date.
FAQ
What's the difference between seconds and milliseconds?
Unix seconds (Linux, PostgreSQL, Python time.time as int) — 10 digits for current dates, e.g. 1700000000. Milliseconds (Java System.currentTimeMillis, JavaScript Date.now, MongoDB) — 13 digits, e.g. 1700000000000. The converter auto-detects scale by digit count in Unix mode.
Is Java timestamp something special?
No, same epoch as Unix (1970-01-01 UTC), Java just defaults to milliseconds. System.currentTimeMillis(), Date.getTime(), Instant.toEpochMilli() are all Unix time × 1000. Instant.getEpochSecond() returns regular seconds.
What is an Excel date number?
Excel and Google Sheets store dates as days (with a fractional part for time of day) since 1900-01-00. Today's value looks like 45000. There's a historical bug: Excel treats 1900 as a leap year (it wasn't), so dates before March 1900 may be off by one day.
What is FILETIME and where does it appear?
Windows FILETIME — 100-nanosecond intervals since 1601-01-01 UTC. Used in WinAPI (CreateFile, FindFirstFile), NTFS, Active Directory (lastLogon, lastLogonTimestamp, pwdLastSet, accountExpires). Current value is around 133...×10⁶.
What is .NET DateTime.Ticks?
C# / .NET uses its own epoch — 0001-01-01 00:00:00 UTC, counting time in 100-nanosecond intervals. DateTime.Now.Ticks is a huge number around 638...×10¹⁰. Formula: ticks = (unixSec + 62135596800) × 10⁷.
What is the year 2038 problem?
A 32-bit signed Unix timestamp overflows on 19 January 2038 at 03:14:07 UTC. Modern systems moved to 64 bits long ago, where overflow is 292 billion years away — but legacy C code or old embedded devices still hit it.
How do I get the current timestamp in different languages?
Unix sec — JS: Math.floor(Date.now()/1000); Python: int(time.time()); Bash: date +%s; Go: time.Now().Unix(); PHP: time(); PostgreSQL: extract(epoch from now())::int. Unix ms — Java: System.currentTimeMillis(); JS: Date.now(). .NET ticks — DateTime.UtcNow.Ticks.