Mon DD, YYYY 12h to SQL datetime converter
Abbreviated month date-time (Oct 29, 2024, 12:00:00 AM) → SQL datetime (YYYY-MM-DD HH:mm:ss)
SQL datetime · YYYY-MM-DD HH:mm:ss
Worked examples
| Instant | Mon DD, YYYY 12h | SQL datetime |
|---|---|---|
| an ordinary afternoon | Jun 29, 2026, 2:30:00 PM | 2026-06-29 14:30:00 |
| a leap day | Feb 29, 2028, 9:05:07 AM | 2028-02-29 09:05:07 |
| the Unix epoch | Jan 01, 1970, 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.
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
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 Mon DD, YYYY 12h 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.