Timestamp to Date Converter
Paste a column of epoch values from a log or a database export and get one readable date per line, plus a table with the detected unit.
Processed locally in your browser· Your data stays in your browser.
What is Timestamp to Date Converter?
Log files and database exports often contain long lists of raw timestamps in mixed units. This tool converts each line on its own, so a value in seconds and another in milliseconds can sit in the same list.
For every line it detects seconds, milliseconds, microseconds or nanoseconds (or uses the unit you force), then prints the date in the zone you choose. The text output uses the format you select, while the table also shows the detected unit and the UTC and local dates side by side.
How does it work?
- Paste one timestamp per line; negative values and fractional seconds such as 1709251200.5 are allowed.
- Choose the time zone (UTC by default) or type an IANA zone name.
- Select the output format: ISO 8601, SQL, RFC 2822 or a readable localized date.
- Copy the resulting dates, one per line, in the same order as your input.
Common use cases
- Turning a column of epoch values from a CSV or SQL export into dates before sharing a report.
- Reading the timestamps in an access or audit log during an incident review.
- Comparing event times in New York and Paris by switching only the display zone.
- Producing SQL-style datetimes (YYYY-MM-DD HH:MM:SS) to paste into a query.
Examples
Try this input in the tool above:
1700000000 1700000000000 -86400 1709251200.5
2023-11-14T22:13:20Z 2023-11-14T22:13:20Z 1969-12-31T00:00:00Z 2024-03-01T00:00:00.500Z
Privacy
Timestamp to Date Converter runs entirely in your browser. The text or files you provide are processed on your device and are not uploaded, logged or stored on our servers.
Limitations
Each line is detected independently, so a short millisecond value (fewer than 12 digits) is read as seconds unless you force the unit; lines that are not numbers are flagged as invalid.
Frequently asked questions
Can I mix seconds and milliseconds in the same list?
Yes, with the unit set to Auto-detect every line is classified by its own magnitude. If your list is homogeneous but contains small values, force the unit to avoid misreads.
What does the SQL format look like?
It prints YYYY-MM-DD HH:MM:SS in the chosen zone, without a zone suffix, which most databases accept for DATETIME columns. Use ISO 8601 if you need the explicit offset.
Is there a limit on the number of lines?
The text output covers every line, while the table shows the first 500 rows to stay responsive. Very large lists are processed in a background worker.
Related tools
Unix Timestamp Converter
Paste an epoch value or a date and get every common representation at once: seconds, milliseconds, ISO 8601, RFC 2822, local time and relative time.
Date & Time
Date to Timestamp Converter
Type a date in almost any common format, choose the zone it is written in, and get the Unix timestamp in seconds and milliseconds.
Date & Time
Current Unix Timestamp
A live clock that shows the current epoch time in seconds and milliseconds, ready to copy, alongside the ISO 8601 UTC date and your local time.
Date & Time
UTC to Local Time Converter
Enter a UTC date and time and see it in New York, Paris, Tokyo or any other zone, with the offset and whether daylight saving time is active.
Date & Time
Local Time to UTC Converter
Enter a wall-clock time from any zone and get the matching UTC time, with a warning when daylight saving makes that local time non-existent or ambiguous.
Date & Time
JWT Expiration Checker
See at a glance whether a token’s time claims put it inside or outside its validity window, and by how much.
Developer Tools
Date Difference Calculator
Enter two dates and get the calendar difference in years, months and days, together with total days, weeks and the number of weekdays.
Date & Time