Month-first vs day-first formats cause data corruption during imports. A CSV with '01/02/2024' could mean January 2 or February 1. Without format specification, systems guess incorrectly, corrupting historical data silently. Always document and validate date formats during import.
12-hour vs 24-hour time creates AM/PM confusion. '6:00' could be morning or evening without AM/PM indicators. Military time (18:00) eliminates ambiguity. For user input, require AM/PM or use 24-hour format; for storage, use 24-hour exclusively.
Daylight Saving Time transitions cause hour-long gaps or overlaps. 2:30 AM doesn't exist on spring-forward days (jumps from 2:00 to 3:00), while 2:30 AM occurs twice on fall-back days. Store UTC timestamps to avoid DST complications, handle local time only for display.
Century ambiguity affects two-digit years: '24' could be 1924 or 2024. Systems guess based on cutoff rules (e.g., <50 means 20xx, ≥50 means 19xx), but these rules vary. Always use four-digit years to eliminate ambiguity, especially for historical or future dates.