DD.MM.YYYY 24h to ISO 8601 (local, ms) converter
European date-time (DD.MM.YYYY, HH:mm:ss) → ISO 8601 local date-time with milliseconds (no offset)
ISO 8601 (local, ms) · YYYY-MM-DDTHH:mm:ss.SSS
Worked examples
| Instant | DD.MM.YYYY 24h | ISO 8601 (local, ms) |
|---|---|---|
| an ordinary afternoon | 29.06.2026, 14:30:00 | 2026-06-29T14:30:00.000 |
| a leap day | 29.02.2028, 09:05:07 | 2028-02-29T09:05:07.000 |
| the Unix epoch | 01.01.1970, 00:00:00 | 1970-01-01T00:00:00.000 |
What this conversion changes
- A date has no time of day: before writing a time or a timestamp, the tool asks which time to assume (the start of the day or noon, in UTC). Nothing is filled in silently.
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, ms) — ISO 8601 local date-time with milliseconds (no offset)
- Pattern
- YYYY-MM-DDTHH:mm:ss.SSS
- Example
- 2024-06-29T00:00:00.500
- Seen in
- SQL Server datetime2 exports, Application logs, JavaScript Date without the Z
Related conversions
- ISO 8601 (local, ms) to DD.MM.YYYY 24h
- DD.MM.YYYY 24h to MM/DD/YYYY
- DD.MM.YYYY 24h to ISO 8601
- DD.MM.YYYY 24h to ISO 8601 (local)
- DD.MM.YYYY 24h to SQL datetime
- DD.MM.YYYY 24h to MM/DD/YYYY 24h
- DD.MM.YYYY 24h to Unix ms
- DD.MM.YYYY 24h to Unix timestamp
- DD.MM.YYYY 24h to M/D/YYYY 12h
- All DD.MM.YYYY 24h conversions
Thousands of values to convert?
CSV batch mode converts an entire column from DD.MM.YYYY 24h to ISO 8601 (local, ms) (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.