Nothing is guessed silently
Is 03/04/2026 the 3rd of April or the 4th of March? It depends on who wrote it, so slash dates are rejected until you declare the order. 12-hour times need AM or PM. A value like 2024-07-01T09:00-05:00[America/New_York] contradicts itself (New York is UTC−04:00 in July), so you choose whether the offset or the zone wins, or reject such rows.
Bare numbers are refused; prefix epoch values with @ so the unit setting applies explicitly. Date-only values are reported but not converted, because a date is not a moment in time.