YYYY.MM.DD 24h to SQL datetime converter
Dotted year-first date-time (YYYY.MM.DD HH:mm:ss) → SQL datetime (YYYY-MM-DD HH:mm:ss)
SQL datetime · YYYY-MM-DD HH:mm:ss
Worked examples
| Instant | YYYY.MM.DD 24h | SQL datetime |
|---|---|---|
| an ordinary afternoon | 2026.06.29 14:30:00 | 2026-06-29 14:30:00 |
| a leap day | 2028.02.29 09:05:07 | 2028-02-29 09:05:07 |
| the Unix epoch | 1970.01.01 00:00:00 | 1970-01-01 00:00:00 |
What this conversion changes
- Both formats carry the same information; only the written layout changes.
YYYY.MM.DD 24h — Dotted year-first date-time (YYYY.MM.DD HH:mm:ss)
- Pattern
- YYYY.MM.DD HH:mm:ss
- Example
- 2021.02.05 19:15:47
- Seen in
- Hungarian and Korean locales, Some camera firmware
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
Thousands of values to convert?
CSV batch mode converts an entire column from YYYY.MM.DD 24h 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.