Interesting comments about dates... although if you think about it - all dates are weird.
What is important to consider though is that for an international website it is important to always represent dates in a commonly understood and interpreted format. In this case the ISO date format is correct and this is what was shown in the example. If the example used the US (or any other regional specific date format) then it would be incorrect. MS-SQL has clearly defined ways of interpreting dates that are presented in ISO format and dates that are not presented in an ISO format will be handled at the whim of whatever local date format is in operation at the time and this may not be, and often is not, what is expected. Consider 3/11 or 11/3 - is this the 3rd day of the 11th month or the 11th day of the 3rd month?
The issue with US format dates is that the day and month are swapped compared to much of the rest of the world. While neither technically correct or incorrect (actually, dammit, I'm from the UK: it is incorrect and please drive on the correct side of the road as well.. 😉 ) it is interesting in that it often matches how we speak a date rather than how we write a date: do you say "the 1st of March" or "March the 1st" (technically "March, the 1st")? Neither is more wrong or right than the other.
All of this is fine when you consider just the Gregorian calendar - other calendars are available.