Mon DD, YYYY 12h — Abbreviated month date-time (Oct 29, 2024, 12:00:00 AM)
Pattern MMM DD, YYYY, h:mm:ss A · e.g. Oct 29, 2024, 12:00:00 AM
About this format
- Fields
- Month, Day, Year, Hour, Min, Sec, AM/PM
- Clock
- 12-hour with AM/PM
- Carries a time zone
- No — the zone must be known from context
- Typically seen in
- macOS Finder, Google Sheets default, Browser history exports
Sample values
- Jun 29, 2026, 2:30:00 PM
- Feb 29, 2028, 9:05:07 AM
- Jan 01, 1970, 12:00:00 AM
Try it: Mon DD, YYYY 12h to ISO 8601
ISO 8601 · YYYY-MM-DDTHH:mm:ss.SSSZ
No time zone in the value: read as UTC.
Convert Mon DD, YYYY 12h to…
- Mon DD, YYYY 12h to M/D/YYYY
- Mon DD, YYYY 12h to MM/DD/YYYY
- Mon DD, YYYY 12h to YYYY
- Mon DD, YYYY 12h to ISO 8601
- Mon DD, YYYY 12h to ISO 8601 (local)
- Mon DD, YYYY 12h to ISO 8601 (local, ms)
- Mon DD, YYYY 12h to SQL datetime
- Mon DD, YYYY 12h to M/D/YYYY 24h
- Mon DD, YYYY 12h to MM/DD/YYYY 24h
- Mon DD, YYYY 12h to M/D/YYYY - 24h
- Mon DD, YYYY 12h to DD.MM.YYYY 24h
- Mon DD, YYYY 12h to YYYY.MM.DD 24h
- Mon DD, YYYY 12h to Unix ms
- Mon DD, YYYY 12h to Unix timestamp
- Mon DD, YYYY 12h to HH:mm MM/DD/YYYY
- Mon DD, YYYY 12h to YYYY-MM-DD 12h
- Mon DD, YYYY 12h to M/D/YYYY 12h
- Mon DD, YYYY 12h to M/D/YYYY h:mm A
- Mon DD, YYYY 12h to Mon D YYYY h:mm A
- Mon DD, YYYY 12h to Long date
Convert to Mon DD, YYYY 12h from…
- M/D/YYYY to Mon DD, YYYY 12h
- MM/DD/YYYY to Mon DD, YYYY 12h
- ISO 8601 to Mon DD, YYYY 12h
- ISO 8601 (local) to Mon DD, YYYY 12h
- ISO 8601 (local, ms) to Mon DD, YYYY 12h
- SQL datetime to Mon DD, YYYY 12h
- M/D/YYYY 24h to Mon DD, YYYY 12h
- MM/DD/YYYY 24h to Mon DD, YYYY 12h
- M/D/YYYY - 24h to Mon DD, YYYY 12h
- DD.MM.YYYY 24h to Mon DD, YYYY 12h
- YYYY.MM.DD 24h to Mon DD, YYYY 12h
- Unix ms to Mon DD, YYYY 12h
- Unix timestamp to Mon DD, YYYY 12h
- HH:mm MM/DD/YYYY to Mon DD, YYYY 12h
- YYYY-MM-DD 12h to Mon DD, YYYY 12h
- M/D/YYYY 12h to Mon DD, YYYY 12h
- M/D/YYYY h:mm A to Mon DD, YYYY 12h
- Mon D YYYY h:mm A to Mon DD, YYYY 12h
- Long date to Mon DD, YYYY 12h