You need to sign in to do that
Don't have an account?
zach
Quick SOQL Date question...
Hey, just wondering how the time zone offset works with SOQL.
If I specify a query as follows:
Select Id from Case where (CreatedDate >= 2006-07-13T00:00:00-07:00 and CreatedDate <= 2006-07-17T23:59:59-07:00 and RecordTypeId = '[some record type id]'
Will the first date constraint automatically get records from the previous day or not?
In this case, it should return records created after 5:00PM on 7/12/2006, right?
If I specify a query as follows:
Select Id from Case where (CreatedDate >= 2006-07-13T00:00:00-07:00 and CreatedDate <= 2006-07-17T23:59:59-07:00 and RecordTypeId = '[some record type id]'
Will the first date constraint automatically get records from the previous day or not?
In this case, it should return records created after 5:00PM on 7/12/2006, right?
When I look at my time zone settings in Windows, my time zone is Mountain Time & it says GMT-07:00, or 7 hours behind GMT. When it's 12:01AM on the 23rd in Grenwich, it's 5:01PM on the 22nd in Denver, right?