Date Format Reference & Converter
Your complete guide to date formats worldwide. Convert, compare, and copy date formats for any programming language.
Today's Date in All FormatsPopular Date Formats
DD/MM/YYYY
31/12/2025
Day-Month-Year format commonly used in Europe, Asia, and most of the world
YYYY-MM-DD
ISO
2025-12-31
ISO 8601 standard format, ideal for sorting and international use
DD/MM
31/12
Short day-month format without year, used for birthdays and recurring dates
MM/YYYY
12/2025
Month-year format commonly used for credit cards, expiration dates, and monthly reports
DD/M/YY
31/12/25
Short format with 2-digit year, compact but can be ambiguous
MM/DD/YYYY
12/31/2025
Month-Day-Year format primarily used in the United States
Today's Date
Date Formatting by Language
Quick Links
Frequently Asked Questions
What is the difference between MM/DD/YYYY and DD/MM/YYYY?
MM/DD/YYYY puts the month first (used in the US), while DD/MM/YYYY puts the day first (used in most other countries). For example, March 4th is 03/04/2026 in MM/DD/YYYY but 04/03/2026 in DD/MM/YYYY.
Which date format should I use for databases?
YYYY-MM-DD (ISO 8601) is the recommended format for databases because it sorts correctly as text, is internationally unambiguous, and is the SQL standard.
What does ISO 8601 mean?
ISO 8601 is an international standard for date and time representation. The date format is YYYY-MM-DD (e.g., 2026-02-03). It's designed to avoid confusion between different regional date formats.