Timestamp to Date
Paste a timestamp from a log or a database and read it as a date in any zone.
Works in your browser. Nothing you type is sent to us.
Timestamp to date
Seconds, milliseconds, microseconds and nanoseconds are told apart by their length.
Date to timestamp
Converted in your browser with your device's clock and time zone data. Nothing is sent to us.
Timestamp to Date at a glance
- Price
- Free
- Data sent to us
- None, it runs in your browser
- Sign-up
- Not needed
- Reads
- Unix time in s, ms, µs, ns, or an ISO date
- Gives
- Date in any zone, ISO 8601, RFC 2822, relative, week
- Zones
- Every zone your browser knows
How to use Timestamp to Date
- Paste the timestampPut the number in the Timestamp box. The unit is read from its length and the date appears in every form, in your zone and UTC.
- Pick a zoneChoose Show in to see the same moment where someone else is. Copy any line with its button.
- Or go the other waySet a date, a time and the zone it is in under Date to timestamp, and copy the seconds or milliseconds.
Paste the timestamp from a log line, a database row or an API response and read it as a full date and time in your zone, in UTC and in any zone you pick, along with the ISO 8601 form with offset, RFC 2822, the relative time and the day and week of the year. Seconds, milliseconds, microseconds and nanoseconds are recognised by their length, and the note under the box says which was used.
How it works
Timestamp to Date is a web page that does its work on your own device. Everything you type or choose is worked out by your browser and never sent to a server, so nothing is stored and there is nothing to delete. There is no account, no sign-up and no limit on how often you use it.
Timestamps in logs and databases
Databases such as the common SQL and NoSQL systems and most logging libraries write Unix time in seconds or milliseconds; some languages' default clocks give microseconds or nanoseconds. If a date comes out in 1970 or far in the future, the unit was read wrong: add or remove three zeros.
Questions
Why does 1700000000 show November 2023?
Because that is when 1.7 billion seconds after 1 January 1970 falls: 14 November 2023 at 22:13:20 UTC.
Other shortcuts
Unix Timestamp Converter · Epoch Converter
More
More Text tools
See all →
Base64 Encoder and Decoder
Text ToolsBase64 both ways: text or a file in, text, a data URI or a file out, with nothing sent anywhere.
JSON, YAML and XML Converter
Text ToolsConvert JSON, YAML and XML into one another as you type, with the errors pointed out, on your device.
Character Counter
Text ToolsCharacters, words and bytes as you type, checked against the limits that matter, counted the way each platform counts.