Skip to content

SQL datetime to Mon DD, YYYY 12h converter

SQL datetime (YYYY-MM-DD HH:mm:ss) → Abbreviated month date-time (Oct 29, 2024, 12:00:00 AM)

Mon DD, YYYY 12h · MMM DD, YYYY, h:mm:ss A

Jun 29, 2022, 1:45:31 PM

Worked examples

InstantSQL datetimeMon DD, YYYY 12h
an ordinary afternoon2026-06-29 14:30:00Jun 29, 2026, 2:30:00 PM
a leap day2028-02-29 09:05:07Feb 29, 2028, 9:05:07 AM
the Unix epoch1970-01-01 00:00:00Jan 01, 1970, 12:00:00 AM

What this conversion changes

  • The 24-hour clock becomes a 12-hour clock with AM/PM; nothing is lost.

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

Mon DD, YYYY 12h — Abbreviated month date-time (Oct 29, 2024, 12:00:00 AM)

Pattern
MMM DD, YYYY, h:mm:ss A
Example
Oct 29, 2024, 12:00:00 AM
Seen in
macOS Finder, Google Sheets default, Browser history exports

Thousands of values to convert?

CSV batch mode converts an entire column from SQL datetime to Mon DD, YYYY 12h (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.