DD.MM.YYYY 24h — European date-time (DD.MM.YYYY, HH:mm:ss)
Pattern DD.MM.YYYY, HH:mm:ss · e.g. 15.05.2024, 21:11:29
About this format
- Fields
- Day, Month, Year, Hour, Min, Sec
- Clock
- 24-hour
- Carries a time zone
- No — the zone must be known from context
- Typically seen in
- German, Russian and Nordic locales, SAP exports, European banking CSVs
Sample values
- 29.06.2026, 14:30:00
- 29.02.2028, 09:05:07
- 01.01.1970, 00:00:00
Try it: DD.MM.YYYY 24h to ISO 8601
ISO 8601 · YYYY-MM-DDTHH:mm:ss.SSSZ
No time zone in the value: read as UTC.
Convert DD.MM.YYYY 24h to…
- DD.MM.YYYY 24h to M/D/YYYY
- DD.MM.YYYY 24h to MM/DD/YYYY
- DD.MM.YYYY 24h to YYYY
- DD.MM.YYYY 24h to ISO 8601
- DD.MM.YYYY 24h to ISO 8601 (local)
- DD.MM.YYYY 24h to ISO 8601 (local, ms)
- DD.MM.YYYY 24h to SQL datetime
- DD.MM.YYYY 24h to M/D/YYYY 24h
- DD.MM.YYYY 24h to MM/DD/YYYY 24h
- DD.MM.YYYY 24h to M/D/YYYY - 24h
- DD.MM.YYYY 24h to YYYY.MM.DD 24h
- DD.MM.YYYY 24h to Unix ms
- DD.MM.YYYY 24h to Unix timestamp
- DD.MM.YYYY 24h to HH:mm MM/DD/YYYY
- DD.MM.YYYY 24h to YYYY-MM-DD 12h
- DD.MM.YYYY 24h to M/D/YYYY 12h
- DD.MM.YYYY 24h to M/D/YYYY h:mm A
- DD.MM.YYYY 24h to Mon DD, YYYY 12h
- DD.MM.YYYY 24h to Mon D YYYY h:mm A
- DD.MM.YYYY 24h to Long date
Convert to DD.MM.YYYY 24h from…
- M/D/YYYY to DD.MM.YYYY 24h
- MM/DD/YYYY to DD.MM.YYYY 24h
- ISO 8601 to DD.MM.YYYY 24h
- ISO 8601 (local) to DD.MM.YYYY 24h
- ISO 8601 (local, ms) to DD.MM.YYYY 24h
- SQL datetime to DD.MM.YYYY 24h
- M/D/YYYY 24h to DD.MM.YYYY 24h
- MM/DD/YYYY 24h to DD.MM.YYYY 24h
- M/D/YYYY - 24h to DD.MM.YYYY 24h
- YYYY.MM.DD 24h to DD.MM.YYYY 24h
- Unix ms to DD.MM.YYYY 24h
- Unix timestamp to DD.MM.YYYY 24h
- HH:mm MM/DD/YYYY to DD.MM.YYYY 24h
- YYYY-MM-DD 12h to DD.MM.YYYY 24h
- M/D/YYYY 12h to DD.MM.YYYY 24h
- M/D/YYYY h:mm A to DD.MM.YYYY 24h
- Mon DD, YYYY 12h to DD.MM.YYYY 24h
- Mon D YYYY h:mm A to DD.MM.YYYY 24h
- Long date to DD.MM.YYYY 24h