SQL datetime to DD.MM.YYYY 24h converter
SQL datetime (YYYY-MM-DD HH:mm:ss) → European date-time (DD.MM.YYYY, HH:mm:ss)
DD.MM.YYYY 24h · DD.MM.YYYY, HH:mm:ss
Worked examples
| Instant | SQL datetime | DD.MM.YYYY 24h |
|---|---|---|
| an ordinary afternoon | 2026-06-29 14:30:00 | 29.06.2026, 14:30:00 |
| a leap day | 2028-02-29 09:05:07 | 29.02.2028, 09:05:07 |
| the Unix epoch | 1970-01-01 00:00:00 | 01.01.1970, 00:00:00 |
What this conversion changes
- Both formats carry the same information; only the written layout changes.
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
DD.MM.YYYY 24h — European date-time (DD.MM.YYYY, HH:mm:ss)
- Pattern
- DD.MM.YYYY, HH:mm:ss
- Example
- 15.05.2024, 21:11:29
- Seen in
- German, Russian and Nordic locales, SAP exports, European banking CSVs
Related conversions
Thousands of values to convert?
CSV batch mode converts an entire column from SQL datetime to DD.MM.YYYY 24h (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.