al_kessler (4/13/2011)

---

Not sure what I'm missing but the only one that failed for me was the datetime. Tried British, German, Italian, US_English. Tried dateformat as ymd, dmy, mdy...

bitbucket-25253 (4/13/2011)

---

Duncan Pryde (4/13/2011)

---

Thanks...

Thanks - although I'd...

It says:

"regardless of any date format or language settings".

You change language settings using SET LANGUAGE and date format settings using...

Thanks for the compliment Jason - glad you liked it.

You're welcome - although I'd hesitate to call 2 questions a series! Unless you're expecting more? :blink:

Try this:

SET DATEFORMAT ydm

GO

SELECT CAST('2011-04-28' AS DATETIME)

or this:

SET LANGUAGE British

GO

SELECT CAST('2011-04-28'...

Thanks for the question

Duncan Pryde (4/12/2011)

---

So do I - which is why I'm replying here. That way I get my point for the post!

I came to this question...

So do I - which is why I'm replying here. That way I get my point for the post!

I came to this question late, and...

rmechaber (4/6/2011)

---

Duncan Pryde (4/6/2011)

---

I'm glad people are liking the question - thanks for the positive comments everyone.

I was motivated to come up with the question after following a discussion relating...

I'll admit that I deliberately chose '04-28-2011' as a...

I'm glad people are liking the question - thanks for the positive comments everyone.

I was motivated to come up with the question after following a discussion relating to a QotD...

I couldn't work out why the create table statement would fail, so thought it was an easy question. It was only when I read the explanation that I realised it...

Patrick2525 (3/30/2011)

---

I think the discussion for the QotD is great, but lets not get too anal. Just as with the certification exam questions, just choose the best answer. Anyone that's...