Skip to content

ISO 8601 (local, ms) to Mon DD, YYYY 12h converter

ISO 8601 local date-time with milliseconds (no offset) → Abbreviated month date-time (Oct 29, 2024, 12:00:00 AM)

Mon DD, YYYY 12h · MMM DD, YYYY, h:mm:ss A

Jun 29, 2024, 12:00:00 AM

Worked examples

InstantISO 8601 (local, ms)Mon DD, YYYY 12h
an ordinary afternoon2026-06-29T14:30:00.000Jun 29, 2026, 2:30:00 PM
a leap day2028-02-29T09:05:07.000Feb 29, 2028, 9:05:07 AM
the Unix epoch1970-01-01T00:00:00.000Jan 01, 1970, 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

Mon DD, YYYY 12h — Abbreviated month date-time (Oct 29, 2024, 12:00:00 AM)

Pattern
MMM DD, YYYY, h:mm:ss A
Example
Oct 29, 2024, 12:00:00 AM
Seen in
macOS Finder, Google Sheets default, Browser history exports

Thousands of values to convert?

CSV batch mode converts an entire column from ISO 8601 (local, ms) to Mon DD, YYYY 12h (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.