Timestamp Converter
Convert Unix timestamps and date-times in both directions, with automatic seconds/milliseconds detection, Local/UTC/city timezone output, and ISO or SQL-style formatting for logs and database work.
Enter Unix Timestamp
Supports seconds and milliseconds with automatic detection
Timezone
Format
Enter your own format
Timestamp Input
Current Time
Timestamp (seconds)
1704067200
Timestamp (ms)
1704067200000
Enter Date and Time
Supports ISO, SQL, and common date-time formats
Timezone
Date Input
Current Time
UTC
01/01/2024 00:00:00
Quick Start
Common Scenarios
Log tracing
convert timestamps in backend logs to readable date-time to locate issues
Token/session expiry
check JWT exp/iat (issued at) and validate the validity period
DB import/export
convert between timestamps and date fields in SQL/CSV
Frontend display
backend passes seconds/milliseconds; format by the user's timezone on the frontend
Cross-timezone debugging
switch city timezones to observe differences (including DST)
Scheduling
verify triggers match expectations (UTC vs local)
API parameters
validate request/response time units (seconds/ms) and formats
Audit/compliance
convert between ISO and timestamps for manual review
Units, Timezones & Formats
Timestamp Rules & Boundaries
Usage Advice
URL Quick Fill
Limitations & Compatibility
Privacy & Security
FAQ
Unix timestamps commonly use 10 digits for seconds and 13 for milliseconds. With UTC selected and format YYYY-MM-DD HH:mm:ss, 1704067200 (seconds) and 1704067200000 (milliseconds) both display 2024-01-01 00:00:00. Units are inferred from a numeric threshold, not digit count; older negative values can be ambiguous, so confirm the source unit.
The timestamp represents one absolute moment. Changing the timezone only changes how that moment is displayed locally, including daylight-saving-time rules; it does not change the underlying Unix value.
ISO is standardized; local display depends on locale and timezone. They can be different views of the same instant.
Prefer ISO with an offset. Check spaces, full-width symbols, timezone offsets, or choose a custom format that matches the input.