Data utilities
Timestamp converter
Flip between Unix timestamps and readable datetimes, compare timezone offsets, and copy clean snippets without touching a shell. This converter keeps incident timelines and audit logs in sync across distributed teams.
Highlights
- Bi-directional conversions keep timestamp and datetime forms synchronized
- Timezone presets cover local machines, UTC, and custom offsets for audits
- Copy-ready snippets document ISO strings, RFC formats, and relative times
Timestamp → Datetime
Paste a Unix timestamp to view formatted values across timezones.
Presets
Load a preset.
Formatted outputs
Copy any result to reuse across tools or APIs.
2026-01-16T09:27:11+00:00
2026-01-16T09:27:11+00:00
Fri, 16 Jan 2026 09:27:11 GMT
1768555631
0 seconds ago
Across key timezones
Quick reads across major tech hubs.
Fri, 16 Jan 2026 09:27:11 UTC
Fri, 16 Jan 2026 04:27:11 EST
Fri, 16 Jan 2026 01:27:11 PST
Fri, 16 Jan 2026 09:27:11 GMT
Fri, 16 Jan 2026 14:57:11 IST
Fri, 16 Jan 2026 17:27:11 +08
Fri, 16 Jan 2026 18:27:11 JST
Copy-ready snippets
Drop these into consoles or scripts.
Format a Unix timestamp using FROM_UNIXTIME.
SELECT FROM_UNIXTIME(1768555631);
Cast a Unix timestamp to a timestamptz.
SELECT TO_TIMESTAMP(1768555631) AT TIME ZONE 'UTC';
Create a Carbon instance from Unix seconds.
Carbon::createFromTimestamp(1768555631, 'UTC')->toIso8601String();
Construct an ISO string from milliseconds.
new Date(1768555631 * 1000).toISOString();
Convert to aware datetime in UTC.
datetime.datetime.fromtimestamp(1768555631, datetime.timezone.utc).isoformat()
Inspect the timestamp in UTC using date.
date -u -d '@1768555631'
Datetime → Timestamp
Pick a date, time, and timezone to get Unix seconds.
1768555631
2026-01-16T09:27:11+00:00
2026-01-16T09:27:11+00:00