Skip to content

DD.MM.YYYY 24h to ISO 8601 (local) converter

European date-time (DD.MM.YYYY, HH:mm:ss) → ISO 8601 local date-time (no offset)

ISO 8601 (local) · YYYY-MM-DDTHH:mm:ss

2024-05-15T21:11:29

Worked examples

InstantDD.MM.YYYY 24hISO 8601 (local)
an ordinary afternoon29.06.2026, 14:30:002026-06-29T14:30:00
a leap day29.02.2028, 09:05:072028-02-29T09:05:07
the Unix epoch01.01.1970, 00:00:001970-01-01T00:00:00

What this conversion changes

  • Both formats carry the same information; only the written layout changes.

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

ISO 8601 (local) — ISO 8601 local date-time (no offset)

Pattern
YYYY-MM-DDTHH:mm:ss
Example
2024-06-29T00:00:00
Seen in
HTML datetime-local inputs, iCalendar floating times, Many database exports

Thousands of values to convert?

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