Interesting question, thanks Steve
Learned something new

Now that is really interesting, thanks Steve
Learned something new today

Nice one, thanks Thomas

This was quite a head-scratcher, thanks Drew
learned something interesting here
Thanks for the added detail, Tom.

Nice back-to-basics question, thanks Steve.

Good to see a question re: MDX, thanks Devendra

Nice one, Avinash - never thought about using this , so learned something.
even though, doubt persists about a feasible reason for doing something in this way.

The database i tested my answer on has "us_english" as the default language.
the script would therefore interpret the date provided as  MM/dd/yyyy

Interestingly, if the SET LANGUAGE British...

Nice one, thanks Steve.
Enjoyed the red herrings....

Nearly missed the AS, myself
fortunately, have just had my second cup of coffee, saw it and the only logical answer  became apparent.
Nice riddle, thanks Steve

That is really interesting, thanks Steve

Interesting.
Have only ever done simple stuff in R (using SQL server), so learned something, thanks Steve

That is really interesting.
Pity this cannot be effected on the new  datetime datatypes (e.g. datetime2)
thanks for the question, Avinash

Nice one to start the week on, thanks Steve.
Have started using this quite a lot lately, (current contract is with a multi-national financial institution)