Skip to content

SQL datetime to ISO 8601 converter

SQL datetime (YYYY-MM-DD HH:mm:ss) → ISO 8601 UTC with milliseconds

Swap → ISO 8601 to SQL datetime

ISO 8601 · YYYY-MM-DDTHH:mm:ss.SSSZ

2022-06-29T13:45:31.000Z

No time zone in the value: read as UTC.

Worked examples

InstantSQL datetimeISO 8601
an ordinary afternoon2026-06-29 14:30:002026-06-29T14:30:00.000Z
a leap day2028-02-29 09:05:072028-02-29T09:05:07.000Z
the Unix epoch1970-01-01 00:00:001970-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

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.