Really?!?!

Try running either

SET DATEFORMAT ydm

or

SET LANGUAGE British

and then see what your results are.

Like someone already pointed out BOL states that DATE and DATETIME2 have Default String literals of YYYY-MM-DD the others do not.