About these timestamp formats
All 33 formats here are UTC-based - there's no timezone conversion, only format conversion. Several (SQL Date, ISO Week Date, Ordinal Date, US/European Date) only store a date, not a time of day, so converting into them loses the time-of-day component (converting a precise instant to one and back will land on midnight of that date, which is expected, not a bug). Syslog and Swatch Internet Time go further and have no date at all - converting back assumes today's date. Formats like Excel Serial Date, .NET Ticks, Windows FILETIME, and Julian Date exist because that's literally how those systems store dates internally - useful when you're debugging data that came from one of them. Stardate is included for fun - it's a fan approximation, not a real historical or scientific format like the others.
What the Timestamp Converter does
The Timestamp Converter converts a moment in time between 33 formats, including Unix seconds, milliseconds, microseconds and nanoseconds, ISO 8601, RFC 2822, SQL DATETIME, Excel serial dates, .NET ticks, Windows FILETIME, Julian dates and ISO week dates.
Everything is in UTC, so the converter changes the format only and never shifts the time zone. You can also start from the current time or pick a date in the calendar.
When to use it
- Reading a Unix timestamp from a log, database column or JWT expiry claim as a real date.
- Matching a date stored as an Excel serial number or .NET ticks to the value in another system.
- Writing correct date strings for HTTP headers, cookies, SQL queries or API requests; for time zones use the Time Zone Converter.
- Investigating an incident by lining up log entries from systems that write dates in different formats.
Worked example
1767225600 · Unix → ISO 8601
2026-01-01T00:00:00.000Z
1767225600 · Unix → RFC 2822
Thu, 01 Jan 2026 00:00:00 GMT
1767225600 · Unix → SQL DateTime
2026-01-01 00:00:00
1767225600 · Unix → Excel Serial Date
46023
1767225600 · Unix → .NET Ticks
639028224000000000
1767225600 · Unix → ISO Week Date
2026-W01-4
Common questions about the Timestamp Converter
How do I know if a Unix timestamp is in seconds or milliseconds?
Count the digits: current dates have 10 digits in seconds and 13 in milliseconds. Choose Unix Timestamp (ms) as the source if your value has 13 digits.
Why does converting to SQL Date lose the time?
Some formats store only a date. Converting into them drops the time of day, and converting back lands on midnight UTC, which is expected.
What is an Excel serial date?
Excel counts days since its epoch at the end of 1899, so 46023 is 1 January 2026. A fractional part stores the time of day, for example .5 for noon.
Is this tool free?
Yes, it's free to use. No signup, no email required. Get results on this page.
How do I get my result?
Use the tool on this page. Your result appears here; no email delivery is required.