Unix Timestamp Converter
Decode any Unix timestamp, scan a JSON blob or log for all embedded timestamps, or convert a local date back to epoch — auto-detects sec / ms / μs / ns, 100% private.
Paste a Unix timestamp — seconds, ms, μs, or ns are all auto-detected.
Enter a timestamp on the left to decode it.
Your data is never uploaded — everything runs in your browser.
What Can You Do With This Tool?
Decode a Single Timestamp in Any Precision
Paste any Unix timestamp and the tool automatically detects whether it is in seconds, milliseconds, microseconds, or nanoseconds based on the plausible date range. All 8 timezone cards update instantly so you can check the moment in Tokyo, New York, and London at the same time.
Scan JSON, Logs, or API Responses for Timestamps
Paste an entire API response, server log, or database dump into the Scan Text tab. The tool highlights every embedded timestamp inline and shows you the decoded date and relative time for each one — without you having to copy them one by one.
Convert a Date & Time Back to Unix Epoch
Pick a date, time, and IANA timezone in the Date → Epoch tab to get the equivalent Unix timestamp in all four precisions. DST transitions are handled correctly with a two-pass correction algorithm — the right epoch whether you are converting a summer or winter date.
Generate SQL WHERE BETWEEN Clauses
Select a start date, end date, and your timestamp column precision to get a ready-to-paste SQL range filter. Choose seconds, milliseconds, or microseconds to match your schema. Copy it directly into your query editor.
Frequently Asked Questions
What is a Unix timestamp?
A Unix timestamp (also called epoch time or POSIX time) is the number of seconds that have elapsed since 00:00:00 UTC on 1 January 1970 — the "Unix epoch". It is timezone-independent and increments monotonically, making it ideal for storing moments in time in databases, APIs, and log files.
How does the tool detect seconds vs milliseconds vs microseconds?
The detector checks whether the absolute value of your number falls within the plausible date range for each scale. For example, a 10-digit number near 1 700 000 000 is a high-confidence seconds timestamp for a date in 2023. A 13-digit number in the same proportional range is milliseconds. The confidence badge tells you whether the detection is high-confidence (in-range match) or low-confidence (fallback by digit count).
What range of timestamps does the tool support?
The plausible range used for high-confidence detection is 2000-01-01 to 2100-01-01 (Unix seconds 946 684 800 to 4 102 444 800). Timestamps outside that range are still decoded but the confidence indicator will show "low". Negative timestamps (before 1970) are technically valid Unix time but will fall outside the high-confidence range.
Does the Scan Text mode upload my data?
No. The scan runs entirely in your browser using a regular expression and the Intl.DateTimeFormat API — there is no server involved. Your log files, API responses, and database dumps never leave your device.
How does the Date → Epoch converter handle daylight saving time?
The converter uses a two-pass iterative correction. It first treats the input time as UTC, then asks Intl.DateTimeFormat what that UTC moment looks like in the target timezone, computes the error, and applies a correction. Repeating the pass once is enough to resolve DST boundary ambiguity in all practical cases.
What is the SQL BETWEEN clause generator useful for?
Many databases store timestamps as Unix integers rather than SQL DATETIME types. When you need to filter rows between two moments, you need the correct integer range for your schema's precision (e.g. milliseconds in PostgreSQL event tables, seconds in older MySQL schemas). The generator converts your local dates to the right integer values and formats the WHERE clause so you can paste it directly.
More Productivity Tools
Explore our other privacy-focused tools designed to boost your productivity
JSON Formatter & Validator
Format, validate, and explore JSON & XML in your browser — tree view, table view, sort keys, no uploads
Base64 Encoder & Decoder
Encode text or files to Base64, generate data URIs, CSS url(), HTML img tags, and URL-safe Base64 — no uploads
CSV Tools
Convert CSV to JSON, SQL, or a live table preview — and JSON arrays back to CSV. Auto-detects delimiter, no uploads