Skip to content

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

ISO 8601 local date-time with milliseconds (no offset) → Dotted year-first date-time (YYYY.MM.DD HH:mm:ss)

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

2024.06.29 00:00:00

Worked examples

InstantISO 8601 (local, ms)YYYY.MM.DD 24h
an ordinary afternoon2026-06-29T14:30:00.0002026.06.29 14:30:00
a leap day2028-02-29T09:05:07.0002028.02.29 09:05:07
the Unix epoch1970-01-01T00:00:00.0001970.01.01 00:00:00

What this conversion changes

  • Dropped on the way out: milliseconds. The conversion is lossy; converting back will not restore them.

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

YYYY.MM.DD 24h — Dotted year-first date-time (YYYY.MM.DD HH:mm:ss)

Pattern
YYYY.MM.DD HH:mm:ss
Example
2021.02.05 19:15:47
Seen in
Hungarian and Korean locales, Some camera firmware

Thousands of values to convert?

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