sqlnaive (11/8/2012)

---

This was a good question. I gave wrong answer or better to say incomplete answer (opted for only 4). Method 2 I was not sure because of code written was not complete.

from my perspective, losing 2 points is not a big deal than gaining small but important piece of knowledge.

derek.colley (11/8/2012)

---

...

Of course, if this argument doesn't apply to DATETIME2 (rather than DATETIME) then I offer you a hearty apology and withdraw my comments.

Still a great QotD. Thank you.

matthew.flower (11/8/2012)

---

While I haven't tried them (have work to do) I am not convinced that any of them "work reliably" when you consider changes to and from daylight savings.

In the UK at least daylight savings changes happen at either 1am which becomes 2am or 2am which becomes 1am, so 2am back to midnight can be 1 hour or 3 hours at least once a year.

Unless I am missing something none of these methods convert both midnight and the current time to UTC before doing the difference between them so I would argue that the correct answer is none of them.

Koen Verbeeck (11/8/2012)

---

So, for which versions do you think the question is meant? Obviously for 2008 and up. There's also a consensus that versions who are no longer supported by Microsoft do not count for Questions of the Day.

Koen Verbeeck (11/8/2012)

---

Nice question Tom, but I doubt if I'll ever use it

(ps: you must be getting old if you can't count to four anymore )

(Bob Brown) (11/8/2012)

---

This is absolutely the worse question I have encountered on QotD. Think I will pass on future Tom questions.