Skip to content

ISO 8601 (local, ms) to Long date converter

ISO 8601 local date-time with milliseconds (no offset) → Long date (December 13, 2023 at 12:24:03 PM)

Long date · MMMM DD, YYYY at h:mm:ss A

June 29, 2024 at 12:00:00 AM

Worked examples

InstantISO 8601 (local, ms)Long date
an ordinary afternoon2026-06-29T14:30:00.000June 29, 2026 at 2:30:00 PM
a leap day2028-02-29T09:05:07.000February 29, 2028 at 9:05:07 AM
the Unix epoch1970-01-01T00:00:00.000January 1, 1970 at 12:00:00 AM

What this conversion changes

  • Dropped on the way out: milliseconds. The conversion is lossy; converting back will not restore them.
  • The 24-hour clock becomes a 12-hour clock with AM/PM; the clock change itself loses nothing.

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

Long date — Long date (December 13, 2023 at 12:24:03 PM)

Pattern
MMMM DD, YYYY at h:mm:ss A
Example
December 13, 2023 at 12:24:03 PM
Seen in
Apple Notes and Photos, Word processors, Printed documents

Thousands of values to convert?

CSV batch mode converts an entire column from ISO 8601 (local, ms) to Long date (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.