Date and time formats
Every format works as both input and output. Open a format for its reference page and converters. The converter reads 82 formats in all; this table lists the ones with a reference page.
| Format | Pattern | Example | Clock | Typically seen in |
|---|---|---|---|---|
| M/D/YYYY US short date (M/D/YYYY) | M/D/YYYY | 6/9/2024 | Date only | Spreadsheets with US locale, Hand-typed US dates |
| MM/DD/YYYY US date (MM/DD/YYYY) | MM/DD/YYYY | 06/09/2024 | Date only | US business documents, Excel (US locale), Exports from US SaaS tools |
| YYYY Year only (YYYY) | YYYY | 2024 | Date only | Reports grouped by year, Copyright lines |
| ISO 8601 ISO 8601 UTC with milliseconds | YYYY-MM-DDTHH:mm:ss.SSSZ | 2024-06-29T00:00:00.000Z | 24-hour | JSON APIs, JavaScript Date.toISOString(), Log files, MongoDB |
| ISO 8601 (local) ISO 8601 local date-time (no offset) | YYYY-MM-DDTHH:mm:ss | 2024-06-29T00:00:00 | 24-hour | HTML datetime-local inputs, iCalendar floating times, Many database exports |
| ISO 8601 (local, ms) ISO 8601 local date-time with milliseconds (no offset) | YYYY-MM-DDTHH:mm:ss.SSS | 2024-06-29T00:00:00.500 | 24-hour | SQL Server datetime2 exports, Application logs, JavaScript Date without the Z |
| SQL datetime SQL datetime (YYYY-MM-DD HH:mm:ss) | YYYY-MM-DD HH:mm:ss | 2022-06-29 13:45:31 | 24-hour | MySQL DATETIME, PostgreSQL timestamp, SQLite, CSV exports from databases |
| M/D/YYYY 24h US short date with 24-hour time | M/D/YYYY HH:mm:ss | 6/29/2024 00:00:00 | 24-hour | Spreadsheets, Point-of-sale exports |
| MM/DD/YYYY 24h US date-time (MM/DD/YYYY HH:mm:ss) | MM/DD/YYYY HH:mm:ss | 06/29/2024 00:00:00 | 24-hour | Excel (US locale), Windows Event Viewer exports, US banking CSVs |
| M/D/YYYY - 24h US date, dash, 24-hour time | M/D/YYYY - HH:mm:ss | 8/26/2023 - 13:33:05 | 24-hour | Some security-camera and device logs |
| DD.MM.YYYY 24h European date-time (DD.MM.YYYY, HH:mm:ss) | DD.MM.YYYY, HH:mm:ss | 15.05.2024, 21:11:29 | 24-hour | German, Russian and Nordic locales, SAP exports, European banking CSVs |
| YYYY.MM.DD 24h Dotted year-first date-time (YYYY.MM.DD HH:mm:ss) | YYYY.MM.DD HH:mm:ss | 2021.02.05 19:15:47 | 24-hour | Hungarian and Korean locales, Some camera firmware |
| Unix ms Unix timestamp in milliseconds | Unix Timestamp (ms) | 1719619200000 | Epoch counter | JavaScript Date.now(), Java System.currentTimeMillis(), Kafka, Analytics exports |
| Unix timestamp Unix timestamp in seconds | Unix Timestamp (sec) | 1719619200 | Epoch counter | Linux and Unix tools, PHP time(), Python time.time(), JWT exp/iat claims, Stripe and most payment APIs |
| HH:mm MM/DD/YYYY Time-first US date (HH:mm MM/DD/YYYY) | HH:mm MM/DD/YYYY | 10:27 07/01/2025 | 24-hour | Some scheduling and telecom exports |
| YYYY-MM-DD 12h Year-first date with 12-hour time | YYYY-MM-DD h:mm:ss A | 2024-06-29 2:30:00 PM | 12-hour | Spreadsheets with mixed locale settings |
| M/D/YYYY 12h US date with 12-hour time (M/D/YYYY h:mm:ss A) | M/D/YYYY h:mm:ss A | 6/29/2024 2:30:00 PM | 12-hour | Excel default date-time (US), Email clients, Google Sheets (US) |
| M/D/YYYY h:mm A US date with 12-hour time, no seconds | M/D/YYYY h:mm A | 6/29/2024 2:30 PM | 12-hour | Calendar exports, Chat logs |
| Mon DD, YYYY 12h Abbreviated month date-time (Oct 29, 2024, 12:00:00 AM) | MMM DD, YYYY, h:mm:ss A | Oct 29, 2024, 12:00:00 AM | 12-hour | macOS Finder, Google Sheets default, Browser history exports |
| Mon D YYYY h:mm A Abbreviated month date-time, no seconds | MMM D YYYY, h:mm A | Apr 1 2024, 8:59 AM | 12-hour | Ticketing systems, Social media exports |
| Long date Long date (December 13, 2023 at 12:24:03 PM) | MMMM DD, YYYY at h:mm:ss A | December 13, 2023 at 12:24:03 PM | 12-hour | Apple Notes and Photos, Word processors, Printed documents |
| YYYY-MM-DD ISO 8601 date (YYYY-MM-DD) | YYYY-MM-DD | 2024-06-29 | Date only | HTML date inputs, SQL DATE columns, JSON APIs (date-only fields), File names and logs |
| RFC 2822 RFC 2822 date-time (e-mail and RSS) | ddd, DD MMM YYYY HH:mm:ss ±HHMM | Sat, 29 Jun 2024 13:45:00 +0000 | 24-hour | E-mail Date: headers, RSS 2.0 pubDate, HTTP Date and Last-Modified headers (GMT form), date -R, PHP DATE_RFC2822, Python email.utils |