SQL datetime — SQL datetime (YYYY-MM-DD HH:mm:ss)
Pattern YYYY-MM-DD HH:mm:ss · e.g. 2022-06-29 13:45:31
About this format
- Fields
- Year, Month, Day, Hour, Min, Sec
- Clock
- 24-hour
- Carries a time zone
- No — the zone must be known from context
- Typically seen in
- MySQL DATETIME, PostgreSQL timestamp, SQLite, CSV exports from databases
Sample values
- 2026-06-29 14:30:00
- 2028-02-29 09:05:07
- 1970-01-01 00:00:00
Try it: SQL datetime to ISO 8601
ISO 8601 · YYYY-MM-DDTHH:mm:ss.SSSZ
No time zone in the value: read as UTC.
Convert SQL datetime to…
- SQL datetime to M/D/YYYY
- SQL datetime to MM/DD/YYYY
- SQL datetime to YYYY
- SQL datetime to ISO 8601
- SQL datetime to ISO 8601 (local)
- SQL datetime to ISO 8601 (local, ms)
- SQL datetime to M/D/YYYY 24h
- SQL datetime to MM/DD/YYYY 24h
- SQL datetime to M/D/YYYY - 24h
- SQL datetime to DD.MM.YYYY 24h
- SQL datetime to YYYY.MM.DD 24h
- SQL datetime to Unix ms
- SQL datetime to Unix timestamp
- SQL datetime to HH:mm MM/DD/YYYY
- SQL datetime to YYYY-MM-DD 12h
- SQL datetime to M/D/YYYY 12h
- SQL datetime to M/D/YYYY h:mm A
- SQL datetime to Mon DD, YYYY 12h
- SQL datetime to Mon D YYYY h:mm A
- SQL datetime to Long date
Convert to SQL datetime from…
- M/D/YYYY to SQL datetime
- MM/DD/YYYY to SQL datetime
- ISO 8601 to SQL datetime
- ISO 8601 (local) to SQL datetime
- ISO 8601 (local, ms) to SQL datetime
- M/D/YYYY 24h to SQL datetime
- MM/DD/YYYY 24h to SQL datetime
- M/D/YYYY - 24h to SQL datetime
- DD.MM.YYYY 24h to SQL datetime
- YYYY.MM.DD 24h to SQL datetime
- Unix ms to SQL datetime
- Unix timestamp to SQL datetime
- HH:mm MM/DD/YYYY to SQL datetime
- YYYY-MM-DD 12h to SQL datetime
- M/D/YYYY 12h to SQL datetime
- M/D/YYYY h:mm A to SQL datetime
- Mon DD, YYYY 12h to SQL datetime
- Mon D YYYY h:mm A to SQL datetime
- Long date to SQL datetime