Skip to content

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

2024-06-29T14:30:00.000Z

No time zone in the value: read as UTC.

Convert YYYY-MM-DD 12h to…

Convert to YYYY-MM-DD 12h from…