Skip to content

DD.MM.YYYY 24h to Mon DD, YYYY 12h converter

European date-time (DD.MM.YYYY, HH:mm:ss) → Abbreviated month date-time (Oct 29, 2024, 12:00:00 AM)

Mon DD, YYYY 12h · MMM DD, YYYY, h:mm:ss A

May 15, 2024, 9:11:29 PM

Worked examples

InstantDD.MM.YYYY 24hMon DD, YYYY 12h
an ordinary afternoon29.06.2026, 14:30:00Jun 29, 2026, 2:30:00 PM
a leap day29.02.2028, 09:05:07Feb 29, 2028, 9:05:07 AM
the Unix epoch01.01.1970, 00:00:00Jan 01, 1970, 12:00:00 AM

What this conversion changes

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

DD.MM.YYYY 24h — European date-time (DD.MM.YYYY, HH:mm:ss)

Pattern
DD.MM.YYYY, HH:mm:ss
Example
15.05.2024, 21:11:29
Seen in
German, Russian and Nordic locales, SAP exports, European banking CSVs

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

Thousands of values to convert?

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