First, some setup: My Site is set to Eastern Time, and the server is located in Eastern Time.
I'm trying to run a query against a list using the created date. I have tried using all variations I can think of and just can't get the results I want. My CAML query has a date specified as
2012-08-25T06:01:49Z which is in ISO8601 format. It is a UTC date. But when I execute my query, it goes to the database as
2012-08-25 06:01:49. So, this works as expected and I get the results I want. Now, if I change my user regional settings to Pacific. The same query sends to the database with
2012-08-25 09:01:49 and I don't get the results I expect.
Since I provided the date in the CAML as UTC, is there any way to get the query to execute with the exact date I passed in instead of translating it using Regional settings? I've torn my hair out enough over this and was hoping someone might have some insight?