ISO 8601 (local, ms) to MM/DD/YYYY converter
ISO 8601 local date-time with milliseconds (no offset) → US date (MM/DD/YYYY)
MM/DD/YYYY · MM/DD/YYYY
Worked examples
| Instant | ISO 8601 (local, ms) | MM/DD/YYYY |
|---|---|---|
| an ordinary afternoon | 2026-06-29T14:30:00.000 | 06/29/2026 |
| a leap day | 2028-02-29T09:05:07.000 | 02/29/2028 |
| the Unix epoch | 1970-01-01T00:00:00.000 | 01/01/1970 |
What this conversion changes
- Dropped on the way out: hour, minutes, seconds, 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
MM/DD/YYYY — US date (MM/DD/YYYY)
- Pattern
- MM/DD/YYYY
- Example
- 06/09/2024
- Seen in
- US business documents, Excel (US locale), Exports from US SaaS tools
Related conversions
Thousands of values to convert?
CSV batch mode converts an entire column from ISO 8601 (local, ms) to MM/DD/YYYY (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.