Mongo ISODate query in Java

Question

I have a mongo query to be executed :

query = { "dateField" : { "$gte" : ISODate('2011-11-10T07:45:32.962Z')  } }

When I do a db.Collection.find(query) on the mongo shell, I am able to retrieve the results.

How could I query this using Java ? I tried constructing a String based on the Date parameter. But in the process of building the String, it eventually gets passed as "ISODate('2011-11-10T07:45:32.962Z')" instead of ISODate('2011-11-10T07:45:32.962Z') (without the surrounding quotes).

What would be the best way to construct this query using the Java API ?

Thanks !

Do not use strings. Strings are not dates. – Scott Hernandez Feb 01 '12 at 07:06 — Scott Hernandez, Feb 01 '12 at 07:06

Eve Freeman · Accepted Answer · 2012-02-01T06:24:07.290

22

Use a regular Java Date--also I recommend the QueryBuilder:

Date d = new Date(); // or make a date out of a string...
DBObject query = QueryBuilder.start().put("dateField").greaterThanEquals(d).get();

edited Feb 01 '12 at 06:24

answered Feb 01 '12 at 05:32

Eve Freeman

32,467
4
86
101

2

Yes, that's the Java equivalent of ISODate(). Try running the query, rather than looking at the toString(). – Eve Freeman Feb 01 '12 at 08:25

Root · Answer 2 · 2015-12-08T19:17:54.667

7

I have search lot and spend more than hour in finding how to get data when having ISODate in mongo model.

As the default constructor for date is deprecated so it was not working in my case.

BasicDBObject searchQuery = new BasicDBObject("_id" , 1);
try {
        searchQuery.append("timestamp",BasicDBObjectBuilder.start( "$gte",new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS\'Z\'").parse("2015-12-07T10:38:17.498Z")).get());
    } catch (ParseException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

edited Dec 08 '15 at 19:17

answered Dec 08 '15 at 15:52

Root

955
1
16
39

Is this an answer or a comment? If it's an answer, please [edit] it to clarify how it addresses the question. – Mogsdad Dec 08 '15 at 17:01
This is answer, I am telling that the simple `Date` not works as it is deprecated and this thing `SimpleDateFormat` was working fine in my case. – Root Jun 14 '16 at 06:56

Mongo ISODate query in Java

2 Answers2