Skip to content

SQL datetime to Long date converter

SQL datetime (YYYY-MM-DD HH:mm:ss) → Long date (December 13, 2023 at 12:24:03 PM)

Swap → Long date to SQL datetime

Long date · MMMM DD, YYYY at h:mm:ss A

June 29, 2022 at 1:45:31 PM

Worked examples

InstantSQL datetimeLong date
an ordinary afternoon2026-06-29 14:30:00June 29, 2026 at 2:30:00 PM
a leap day2028-02-29 09:05:07February 29, 2028 at 9:05:07 AM
the Unix epoch1970-01-01 00:00:00January 1, 1970 at 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

Long date — Long date (December 13, 2023 at 12:24:03 PM)

Pattern
MMMM DD, YYYY at h:mm:ss A
Example
December 13, 2023 at 12:24:03 PM
Seen in
Apple Notes and Photos, Word processors, Printed documents

Thousands of values to convert?

CSV batch mode converts an entire column from SQL datetime to Long date (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.