Adam wrote:

Was it out by exactly a number of hours but the minutes accurate or
was it just sort of randomly wrong? There is a client timezone
redirection setting in terminal services that may confuse things.
-------

Yes, exactly one hour.

So, are you suggesting that if someone remote desktop'ed into the server
from a different time zone that this could have confused things?

For the record, I saw this occur by running the query on the server
itself, not from a remote client. Well, actually, from both, yielding
the same results.