Skip to content

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.

FormatPatternExampleClockTypically 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