Skip to content

SQL datetime to YYYY.MM.DD 24h converter

SQL datetime (YYYY-MM-DD HH:mm:ss) → Dotted year-first date-time (YYYY.MM.DD HH:mm:ss)

YYYY.MM.DD 24h · YYYY.MM.DD HH:mm:ss

2022.06.29 13:45:31

Worked examples

InstantSQL datetimeYYYY.MM.DD 24h
an ordinary afternoon2026-06-29 14:30:002026.06.29 14:30:00
a leap day2028-02-29 09:05:072028.02.29 09:05:07
the Unix epoch1970-01-01 00:00:001970.01.01 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

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

Thousands of values to convert?

CSV batch mode converts an entire column from SQL datetime to YYYY.MM.DD 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.