Skip to content

ISO 8601 (local, ms) to Unix timestamp converter

ISO 8601 local date-time with milliseconds (no offset) → Unix timestamp in seconds

Unix timestamp · Unix Timestamp (sec)

1719619200

No time zone in the value: read as UTC.

Worked examples

InstantISO 8601 (local, ms)Unix timestamp
an ordinary afternoon2026-06-29T14:30:00.0001782743400
a leap day2028-02-29T09:05:07.0001835427907
the Unix epoch1970-01-01T00:00:00.0000

What this conversion changes

  • Unix timestamp has no time zone of its own: the input is read as UTC unless it carries an offset, then counted in seconds from the Unix epoch.
  • Dropped on the way out: milliseconds. The conversion is lossy; converting back will not restore them.

ISO 8601 (local, ms) — ISO 8601 local date-time with milliseconds (no offset)

Pattern
YYYY-MM-DDTHH:mm:ss.SSS
Example
2024-06-29T00:00:00.500
Seen in
SQL Server datetime2 exports, Application logs, JavaScript Date without the Z

Unix timestamp — Unix timestamp in seconds

Pattern
Unix Timestamp (sec)
Example
1719619200
Seen in
Linux and Unix tools, PHP time(), Python time.time(), JWT exp/iat claims, Stripe and most payment APIs

Thousands of values to convert?

CSV batch mode converts an entire column from ISO 8601 (local, ms) to Unix timestamp (or any of the 82 formats, with time-zone shifts), entirely in your browser, with no row limit set by us (your device's memory is the practical ceiling). $9.99/month, hides the ads, cancel anytime.