Skip to content

Long date to DD.MM.YYYY 24h converter

Long date (December 13, 2023 at 12:24:03 PM) → European date-time (DD.MM.YYYY, HH:mm:ss)

DD.MM.YYYY 24h · DD.MM.YYYY, HH:mm:ss

13.12.2023, 12:24:03

Worked examples

InstantLong dateDD.MM.YYYY 24h
an ordinary afternoonJune 29, 2026 at 2:30:00 PM29.06.2026, 14:30:00
a leap dayFebruary 29, 2028 at 9:05:07 AM29.02.2028, 09:05:07
the Unix epochJanuary 1, 1970 at 12:00:00 AM01.01.1970, 00:00:00

What this conversion changes

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

Long date — Long date (December 13, 2023 at 12:24:03 PM)

Pattern
MMMM DD, YYYY at h:mm:ss A
Example
December 13, 2023 at 12:24:03 PM
Seen in
Apple Notes and Photos, Word processors, Printed documents

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

Thousands of values to convert?

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