Long date to SQL datetime converter
Long date (December 13, 2023 at 12:24:03 PM) → SQL datetime (YYYY-MM-DD HH:mm:ss)
SQL datetime · YYYY-MM-DD HH:mm:ss
Worked examples
| Instant | Long date | SQL datetime |
|---|---|---|
| an ordinary afternoon | June 29, 2026 at 2:30:00 PM | 2026-06-29 14:30:00 |
| a leap day | February 29, 2028 at 9:05:07 AM | 2028-02-29 09:05:07 |
| the Unix epoch | January 1, 1970 at 12:00:00 AM | 1970-01-01 00:00:00 |
What this conversion changes
- The 12-hour clock with AM/PM becomes a 24-hour clock; nothing is lost.
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
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 Long date 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.