Mon DD, YYYY 12h to ISO 8601 (local, ms) converter
Abbreviated month date-time (Oct 29, 2024, 12:00:00 AM) → ISO 8601 local date-time with milliseconds (no offset)
ISO 8601 (local, ms) · YYYY-MM-DDTHH:mm:ss.SSS
Worked examples
| Instant | Mon DD, YYYY 12h | ISO 8601 (local, ms) |
|---|---|---|
| an ordinary afternoon | Jun 29, 2026, 2:30:00 PM | 2026-06-29T14:30:00.000 |
| a leap day | Feb 29, 2028, 9:05:07 AM | 2028-02-29T09:05:07.000 |
| the Unix epoch | Jan 01, 1970, 12:00:00 AM | 1970-01-01T00:00:00.000 |
What this conversion changes
- A date has no time of day: before writing a time or a timestamp, the tool asks which time to assume (the start of the day or noon, in UTC). Nothing is filled in silently.
- 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, 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
Related conversions
Thousands of values to convert?
CSV batch mode converts an entire column from Mon DD, YYYY 12h to ISO 8601 (local, ms) (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.