YYYY-MM-DD 12h — Year-first date with 12-hour time
Pattern YYYY-MM-DD h:mm:ss A · e.g. 2024-06-29 2:30:00 PM
About this format
- Fields
- Year, Month, Day, 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
- Spreadsheets with mixed locale settings
Sample values
- 2026-06-29 2:30:00 PM
- 2028-02-29 9:05:07 AM
- 1970-01-01 12:00:00 AM
Try it: YYYY-MM-DD 12h to ISO 8601
ISO 8601 · YYYY-MM-DDTHH:mm:ss.SSSZ
No time zone in the value: read as UTC.
Convert YYYY-MM-DD 12h to…
- YYYY-MM-DD 12h to M/D/YYYY
- YYYY-MM-DD 12h to MM/DD/YYYY
- YYYY-MM-DD 12h to YYYY
- YYYY-MM-DD 12h to ISO 8601
- YYYY-MM-DD 12h to ISO 8601 (local)
- YYYY-MM-DD 12h to ISO 8601 (local, ms)
- YYYY-MM-DD 12h to SQL datetime
- YYYY-MM-DD 12h to M/D/YYYY 24h
- YYYY-MM-DD 12h to MM/DD/YYYY 24h
- YYYY-MM-DD 12h to M/D/YYYY - 24h
- YYYY-MM-DD 12h to DD.MM.YYYY 24h
- YYYY-MM-DD 12h to YYYY.MM.DD 24h
- YYYY-MM-DD 12h to Unix ms
- YYYY-MM-DD 12h to Unix timestamp
- YYYY-MM-DD 12h to HH:mm MM/DD/YYYY
- YYYY-MM-DD 12h to M/D/YYYY 12h
- YYYY-MM-DD 12h to M/D/YYYY h:mm A
- YYYY-MM-DD 12h to Mon DD, YYYY 12h
- YYYY-MM-DD 12h to Mon D YYYY h:mm A
- YYYY-MM-DD 12h to Long date
Convert to YYYY-MM-DD 12h from…
- M/D/YYYY to YYYY-MM-DD 12h
- MM/DD/YYYY to YYYY-MM-DD 12h
- ISO 8601 to YYYY-MM-DD 12h
- ISO 8601 (local) to YYYY-MM-DD 12h
- ISO 8601 (local, ms) to YYYY-MM-DD 12h
- SQL datetime to YYYY-MM-DD 12h
- M/D/YYYY 24h to YYYY-MM-DD 12h
- MM/DD/YYYY 24h to YYYY-MM-DD 12h
- M/D/YYYY - 24h to YYYY-MM-DD 12h
- DD.MM.YYYY 24h to YYYY-MM-DD 12h
- YYYY.MM.DD 24h to YYYY-MM-DD 12h
- Unix ms to YYYY-MM-DD 12h
- Unix timestamp to YYYY-MM-DD 12h
- HH:mm MM/DD/YYYY to YYYY-MM-DD 12h
- M/D/YYYY 12h to YYYY-MM-DD 12h
- M/D/YYYY h:mm A to YYYY-MM-DD 12h
- Mon DD, YYYY 12h to YYYY-MM-DD 12h
- Mon D YYYY h:mm A to YYYY-MM-DD 12h
- Long date to YYYY-MM-DD 12h