Free tool
Unix Timestamp Converter With Time Zones and a Bulk Log Mode
Paste a number from a log or a database and see the exact moment it stands for, in UTC, your own time zone and any other you add. Go the other way by entering a date and time, or convert a whole list of timestamps at once.
Timestamp to date
Start and end of the day, month and year
Many timestamps at once
Paste a list or log lines. Every number of 9 to 19 digits gets its date written after it, in the unit set above.
Show times
Date to timestamp
Your time zone: .
All conversion is worked out in your browser and nothing is sent anywhere. Your display choices are remembered on this device.
Reading a number from a log or database
A Unix timestamp counts time from a fixed starting moment, so it looks like 1761100000, which is hard to read. Paste it in the top box and the date appears along with a live Now clock at the top of the page. Use now fills the box with the current time, and Copy link makes an address that carries the number you are looking at.
The result lists the moment in UTC, in your time zone, in ISO 8601 and RFC 2822, as a day of the year and an ISO week, as a spreadsheet date number, and as a phrase such as how long ago it was.
Seconds, milliseconds and the rest
| Unit setting | Meaning |
|---|---|
| Guess from length | The default. The tool picks the unit from the number of digits |
| Seconds | One unit is a second |
| Milliseconds | One unit is a thousandth of a second, as in JavaScript |
| Microseconds | One unit is a millionth of a second |
| Nanoseconds | One unit is a billionth of a second |
Guessing is helpful, but a wrong unit gives a date many years out. If a result looks odd, set the unit by hand and see which one gives a date that makes sense for your data.
Time zones and display choices
Show times lets you switch between your own time zone and UTC. Also in this time zone adds a second zone from a long list, which is handy when you work with someone abroad. Clock chooses a 24 hour or 12 hour display.
The panel Start and end of the day, month and year gives the timestamps for those boundaries in the zone you picked, which is the quickest way to build a date range filter for a report.
Going from a date to a number
Under Date to timestamp, enter a date and time, say whether it is in your time zone or UTC, and the number appears. Set to now fills in the present moment.
You can also paste a date in the top box and the tool reads it. Be exact about the zone. A date without one is read in the zone you have selected, so the same text can give two different numbers.
Quick sanity checks for a timestamp
- A value of 10 digits is normally in seconds.
- A value of 13 digits is normally in milliseconds.
- If the year looks wrong by about 50, the value may be a count from a different starting point, such as a spreadsheet date number.
- If the hour is off by a whole number, the time zone setting is the first suspect.
The converter prints the spreadsheet date number as one of its results, which helps when a sheet and a database disagree.
Many timestamps at once
The Many timestamps at once box takes a list or whole log lines. Every number of 9 to 19 digits gets its date written after it, using the unit setting above. Choose Dates in UTC or your own time zone, then Copy result. It is a fast way to make an export or an error log readable for a colleague who does not read epoch numbers.
Matching on length means an ordinary long number such as an order ID can be changed too, so scan the output before you pass it on. Forms and checkout tools often store times this way, and our Webflow integration page covers how we connect them.
Frequently asked questions
What is a Unix timestamp?
It is a count of time since a fixed starting point, usually written as a number of seconds. It does not depend on any time zone.
Why does my timestamp give a date in the wrong year?
The unit is probably wrong. A value in milliseconds read as seconds lands far in the future. Set the unit by hand to check.
Can I convert a date to a timestamp?
Yes. Use the Date to timestamp section and pick whether the time is in your zone or in UTC.
Can it convert a whole list?
Yes. Paste the list or log lines into the bulk box, and each number of 9 to 19 digits is followed by its date.
Does the clock at the top run all the time?
Yes. It shows the current Unix time as it ticks, and Use now copies that moment into the converter.
Is anything sent to a server?
No. Every conversion is worked out by your browser.
More free tools
- Cron expression generator: Build and read cron schedules in Unix, Quartz and AWS formats, with the next run times.
- time zone converter: Convert one time to many cities, find a meeting slot on 24-hour strips and save a calendar file.
- JWT decoder: Decode a JSON Web Token, read its claims and expiry, and check the signature with a key.
- UUID generator: Make v4, v7 or nil UUIDs in bulk and check whether a UUID is valid.
- JSON formatter: Format, minify, validate and repair JSON, browse it as a tree, or convert it to YAML or CSV.