SQL datetime to ISO 8601 converter
SQL datetime (YYYY-MM-DD HH:mm:ss) → ISO 8601 UTC with milliseconds
ISO 8601 · YYYY-MM-DDTHH:mm:ss.SSSZ
No time zone in the value: read as UTC.
Worked examples
| Instant | SQL datetime | ISO 8601 |
|---|---|---|
| an ordinary afternoon | 2026-06-29 14:30:00 | 2026-06-29T14:30:00.000Z |
| a leap day | 2028-02-29 09:05:07 | 2028-02-29T09:05:07.000Z |
| the Unix epoch | 1970-01-01 00:00:00 | 1970-01-01T00:00:00.000Z |
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.
SQL datetime — SQL datetime (YYYY-MM-DD HH:mm:ss)
- Pattern
- YYYY-MM-DD HH:mm:ss
- Example
- 2022-06-29 13:45:31
- Seen in
- MySQL DATETIME, PostgreSQL timestamp, SQLite, CSV exports from databases
ISO 8601 — ISO 8601 UTC with milliseconds
- Pattern
- YYYY-MM-DDTHH:mm:ss.SSSZ
- Example
- 2024-06-29T00:00:00.000Z
- Seen in
- JSON APIs, JavaScript Date.toISOString(), Log files, MongoDB
Related conversions
Thousands of values to convert?
CSV batch mode converts an entire column from SQL datetime to ISO 8601 (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.