In SQL, dates are typically stored and displayed in the format YYYY-MM-DD, which follows the ISO 8601 standard:
- YYYY - Four-digit year (e.g., 2023)
- MM - Two-digit month (01-12)
- DD - Two-digit day (01-31)
This format ensures dates are sorted chronologically when ordered alphabetically.