Skip to content

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

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

ISO 8601 (local) · YYYY-MM-DDTHH:mm:ss

2024-10-29T00:00:00

Worked examples

InstantMon DD, YYYY 12hISO 8601 (local)
an ordinary afternoonJun 29, 2026, 2:30:00 PM2026-06-29T14:30:00
a leap dayFeb 29, 2028, 9:05:07 AM2028-02-29T09:05:07
the Unix epochJan 01, 1970, 12:00:00 AM1970-01-01T00:00:00

What this conversion changes

  • The 12-hour clock with AM/PM becomes a 24-hour clock; nothing is lost.

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

ISO 8601 (local) — ISO 8601 local date-time (no offset)

Pattern
YYYY-MM-DDTHH:mm:ss
Example
2024-06-29T00:00:00
Seen in
HTML datetime-local inputs, iCalendar floating times, Many database exports

Thousands of values to convert?

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