Thanks for the question.
I tried all 4 select statements in 2005 as well as in 2008 without changing LANGUATE 7 DATEFORMAT. All the 4 statements worked. So selected all of them.
I overlooked "regardless of any LANGUAGE or DATEFORMAT settings? (select 2)".
Lost the point.
It was a learning for me.