Unix Timestamp Converter

Convert between Unix epoch timestamps (seconds or milliseconds since 1970-01-01) and human-readable dates in any timezone. Includes a current-timestamp display, ISO 8601 formatting, and 12/24-hour modes.

Unix Timetimestamp (sec)

DateTime

ConvertResult

Timetimestamp(sec): —

Timetimestamp(millisec): —

Date(ISO): —

Date(local): —

RelativeTime: —

Unix Timestamp Converter — Seconds / Milliseconds Online

About this tool

A Unix timestamp counts seconds (or milliseconds) since 1970-01-01 00:00:00 UTC. It is the lingua franca of databases, logs, APIs, and cron jobs. This tool converts between seconds/milliseconds and human-readable dates, showing UTC, your local timezone, weekday, and ISO 8601 string.

How to use

Pick direction: timestamp → date, or date → timestamp
Enter the timestamp (auto-detects 10-digit sec / 13-digit ms) or pick a date
Output shows UTC and your local timezone; copy with one click

Use Cases

Decoding 1749120000 from a database into a readable date
Verifying cron schedule execution times
Cross-timezone collaboration: share timestamps, render in your TZ
Storing ISO 8601 strings as compact timestamps

FAQ

Q: 10 or 13 digits?
A: 10 = seconds (covers 1970-2038). 13 = milliseconds (JS Date.now()). The tool auto-detects.

Q: Wrong time displayed?
A: Check timezone. We use your browser locale; China is UTC+8.

Q: 2038 problem?
A: 32-bit signed second timestamps overflow on 2038-01-19. Modern systems use 64-bit.

Tips & Related Tools

MySQL: UNIX_TIMESTAMP() returns seconds, FROM_UNIXTIME() reverses.

JS: Math.floor(Date.now()/1000) for seconds; new Date(ts*1000) for Date.

Python: time.time() returns float seconds; datetime.fromtimestamp(ts, tz) reverses.

Common Use Cases

Use the Timestamp Converter online for these scenarios:

Log debugging: Convert Unix timestamps to readable dates
Database queries: Debug SQL like `WHERE created_at > 1719254400`
API integration:: Handle ISO 8601 / Unix timestamps in JSON

Timezone calculation: Calculate time differences for cross-timezone teams

Frontend development:: Convert between JavaScript Date and backend timestamps

Frequently Asked Questions

Here are the most common questions:

Q: Is JavaScript timestamp seconds or milliseconds?
A: JavaScript Date.now() returns milliseconds. Unix timestamps are usually seconds.

Q: How does timezone work?
A: Timestamps are UTC, timezone-independent. Display converts to local timezone automatically.

Q: Year 2038 problem?
A: 32-bit Unix timestamp overflows at 2038-01-19. 64-bit is standard now, no problem.