I distinctly remember SQL Server 2000 pulling that one on me. I had switched a DB app over to using ISO dates exclusively in its queries to avoid the month-day-ordering confusion and then the bloody thing earnestly started to parse yyyy-mm-dd dates as yyyy-dd-mm at every chance it got. So much for unambiguous date formats!