ISO 8601 (local) to SQL datetime converter
ISO 8601 local date-time (no offset) → SQL datetime (YYYY-MM-DD HH:mm:ss)
SQL datetime · YYYY-MM-DD HH:mm:ss
Worked examples
| Instant | ISO 8601 (local) | SQL datetime |
|---|---|---|
| an ordinary afternoon | 2026-06-29T14:30:00 | 2026-06-29 14:30:00 |
| a leap day | 2028-02-29T09:05:07 | 2028-02-29 09:05:07 |
| the Unix epoch | 1970-01-01T00:00:00 | 1970-01-01 00:00:00 |
What this conversion changes
- Both formats carry the same information; only the written layout changes.
ISO 8601 (local) — ISO 8601 local date-time (no offset)
- Pattern
- YYYY-MM-DDTHH:mm:ss
- Example
- 2024-06-29T00:00:00
- Seen in
- HTML datetime-local inputs, iCalendar floating times, Many database exports
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
Related conversions
- SQL datetime to ISO 8601 (local)
- ISO 8601 (local) to MM/DD/YYYY
- ISO 8601 (local) to ISO 8601
- ISO 8601 (local) to MM/DD/YYYY 24h
- ISO 8601 (local) to DD.MM.YYYY 24h
- ISO 8601 (local) to Unix ms
- ISO 8601 (local) to Unix timestamp
- ISO 8601 (local) to M/D/YYYY 12h
- ISO 8601 (local) to Long date
- All ISO 8601 (local) conversions
Thousands of values to convert?
CSV batch mode converts an entire column from ISO 8601 (local) to SQL datetime (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.