Unix Timestamp Converter — Convert Timestamp to Date & Datetime Online

Unix timestamps are always in UTC (Coordinated Universal Time) — they count seconds since January 1, 1970, 00:00:00 UTC. When you convert a Unix timestamp to a date and time, the tool above lets you display the result in any time zone, not just UTC. Use the time zone selector to convert from UTC to your local time, or to any other region. To convert time to Unix timestamp from a UTC datetime, set the time zone to UTC before converting. This utc timestamp converter keeps epoch math consistent while you compare regions.

When you convert a Unix timestamp to date values for APIs or logs, this tool auto-detects seconds vs milliseconds and shows ISO 8601 plus your chosen IANA time zone. To convert time to Unix timestamp from a calendar date, use the Human → Epoch panel with UTC or local time. Nothing is uploaded: all date math runs locally in your browser.

• Convert Unix timestamp to datetime, date, and time in any IANA time zone
• Convert time to Unix timestamp from ISO or pasted human-readable dates
• UTC and local display — switch zones without reloading
• ISO 8601, relative time, and one-click copy on every output
• Works as a Linux timestamp converter for stat, logs, and shell output

• Convert Unix timestamp to datetime — Paste any epoch value (e.g. 1747310400) to get the full date, time, and day of the week instantly.
• Convert timestamp to date in SQL — Copy the human-readable date output to verify SQL query results or debug database timestamp columns.
• Convert Unix timestamp in Excel — Get the date string from any Unix value, then paste it into Excel as a date value. Excel stores dates as days since 1900-01-01; use =(A1/86400)+25569 to convert directly in a cell.
• Linux timestamp converter — Linux stores file modification times as Unix timestamps. Convert any ls -la or stat output timestamp to a readable date here.
• Convert timestamp to date in Python — Verify Python datetime.fromtimestamp() results by cross-checking with this tool.
• Google Sheets: convert date to Unix timestamp — To get a Unix timestamp from a date in Google Sheets, use =(A1-DATE(1970,1,1))*86400 where A1 contains your date.
• BigQuery: convert timestamp to date — Use DATE(TIMESTAMP_SECONDS(your_column)) in BigQuery SQL, or verify your epoch values here first.

• Unix epoch timestamps ≥ 1,000,000,000,000 are almost always milliseconds.
• Always prefer ISO 8601 (YYYY-MM-DDTHH:MM:SSZ) when storing dates as strings.
• Be explicit about UTC vs local time in logs to avoid daylight-saving bugs.
• Java, JavaScript, and many APIs use milliseconds; PHP and classic Unix use seconds.
• The signed 32-bit epoch overflows on 2038-01-19 — use 64-bit types for new code.