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.
2025-11-30T22:26:49+00:00
2025-11-30T22:26:49+00:00
Sun, 30 Nov 2025 22:26:49 GMT
1764541609
0 seconds ago
Across key timezones
Quick reads across major tech hubs.
Sun, 30 Nov 2025 22:26:49 UTC
Sun, 30 Nov 2025 17:26:49 EST
Sun, 30 Nov 2025 14:26:49 PST
Sun, 30 Nov 2025 22:26:49 GMT
Mon, 01 Dec 2025 03:56:49 IST
Mon, 01 Dec 2025 06:26:49 +08
Mon, 01 Dec 2025 07:26:49 JST
Copy-ready snippets
Drop these into consoles or scripts.
Format a Unix timestamp using FROM_UNIXTIME.
SELECT FROM_UNIXTIME(1764541609);
Cast a Unix timestamp to a timestamptz.
SELECT TO_TIMESTAMP(1764541609) AT TIME ZONE 'UTC';
Create a Carbon instance from Unix seconds.
Carbon::createFromTimestamp(1764541609, 'UTC')->toIso8601String();
Construct an ISO string from milliseconds.
new Date(1764541609 * 1000).toISOString();
Convert to aware datetime in UTC.
datetime.datetime.fromtimestamp(1764541609, datetime.timezone.utc).isoformat()
Inspect the timestamp in UTC using date.
date -u -d '@1764541609'
Datetime → Timestamp
Pick a date, time, and timezone to get Unix seconds.
1764541609
2025-11-30T22:26:49+00:00
2025-11-30T22:26:49+00:00