In order to write a where clause against a datetime field, you need to format your dateTime object into the following format:
WHERE SystemModstamp > 2005-10-08T01:02:03Z
How do you correctly convert the dateTime object to a String?
asked Jan 29, 2014 at 15:59
Add a comment
|
2 Answers
Datetime dt = Datetime.now();
String formattedDt = dt.formatGmt('yyyy-MM-dd\'T\'HH:mm:ss\'Z\'');
Update: Another option is to use SOQL dynamic binding, no formatting required.
Datetime dt = Datetime.now();
String query = 'SELECT Id FROM User WHERE SystemModstamp > :dt '
List<SObject> results = Database.query(query);
answered Jan 29, 2014 at 15:59
-
1* I think, with the first method, you will lost the timezone info,
JSON.serialize(dt).replace('"', '')can solve it. * with the second method,:dtmust be in the same scope withDatabase.query(soql)– Hao LiuMay 8, 2015 at 7:09 -
The answer here is almost correct. Specifying Z in the formatting string is essentially saying that it is formatted in Zulu. Thus the problem is two fold, one yo have to convert it to Zulu and second, the format hh will provide you with 12 hour. HH will provide you with military time (which is what Salesforce uses on the DB Level). Try this if you need to use dynamic SOQL for the date/time: DateTime dt = System.now(); String formattedDt = dt.format('yyyy-MM-dd\'T\'HH:mm:ss\'Z\'Zulu'); May 31, 2016 at 23:02
-
1
Just use datetime variable in the SOQL where clause.
For example:
Datetime dt = DateTime.newInstance(2005,10,8,01,02,03);
List<Account> accounts = [SELECT Id, Name FROM Account WHERE CreatedDate < :dt];
System.debug(accounts.size());
-
You can do that if you are using a non-string query. If you want to use Database.query('query string here'); then you need to correctly format the datetime object before using it in a query. I have been using string based queries because I generate the list of all columns at runtime. Is there a way to do that using the [SELECT ...] syntax? (that should probably be a separate SE question) Jan 29, 2014 at 17:05
-