MongoDB Query by Date in Java [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 7 years ago.

Improve this question

I`m trying to query mongodb for documents where "date" is betwen two dates. Sample data is:

{
        "_id" : ObjectId("4fad0af6709fbc1d481c3e05"),
        "ID" : NumberLong("200930746205085696"),
        "text" : "Forgot my charger...:(",
        "date" : ISODate("2012-06-14T10:49:57Z"),
        "sentiment" : "NEG"
}

My Java code is:

DBCursor cursor = null;
DB db = connect();

    Date startDate = new Date(System.currentTimeMillis() - (long)(numOfTimePeriods+1)*time);
    Date endDate = new Date(System.currentTimeMillis() - (long)numOfTimePeriods*time);
    DBObject query = new BasicDBObject();
    query.put("date", new BasicDBObject("$gt", startDate).append("$lte", endDate));

    cursor = db.getCollection("status").find(query);

but the cursor object has no results.

Query object looks like this:

{ "date" : { "$gt" : { "$date" : "2012-05-15T00:16:15.184Z"} , "$lte" : { "$date" : "2012-06-14T10:16:15.184Z"}}}

I suspect the problem is the date representation in DB. Any suggestions on this?

Yes, you are right, it seems to work! The problem was the data, I queried the period for there are no documents to fetch. Silly me! Thanks for yout help! — andjelko
– andjelko, Commented Jun 14, 2012 at 10:48
Just take a look at stackoverflow.com/questions/6840540/java-mongodb-query-by-date It's already solved there. — josete
– josete, Commented Oct 31, 2012 at 16:50
Possible duplicate of Date query with ISODate in mongodb doesn't seem to work — Alper t. Turker
– Alper t. Turker, Commented Jan 13, 2018 at 15:17

JXue · Accepted Answer · 2013-01-03 07:10:15Z

1

That $date representation is just the toString representation in the Java driver, of a Date. It uses the strict JSON/BSON representation, rather than the extended 10gen BSON where values can be objects represented like they are in the shell. You shouldn't try to query in the shell using the toString output like that, because it won't work for a lot of cases.

answered Jan 3, 2013 at 7:10

JXue

111 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

jocelyn · Accepted Answer · 2012-06-14 09:48:32Z

-1

Aren't you supposed to use the and operator in your query ?

db.foo.find( { $and: [ { date: { $gt: startDate } }, {date : { $lt: endDate} }  ] } )

answered Jun 14, 2012 at 9:48

jocelyn

8987 silver badges13 bronze badges

5 Comments

Thilo Over a year ago

No, I think the query was fine. I use a very similar one, too, and it works.

jocelyn Over a year ago

$and is implcit on a property if you append values ?

Thilo Over a year ago

mongodb.org/display/DOCS/… "You can also combine these operators to specify ranges" Not sure if this works in the general case (with other operators). If you have time, can you try to combine $gt with $nin or something?

andjelko Over a year ago

No, I tried $and operator, tried from cmd, too, but with no success.

andjelko Over a year ago

Code seems to work, I made a mistake in date range I queried. I`ll confirm it works when app finishes the proccessing and answer the question. Thanks for help!

Collectives™ on Stack Overflow

MongoDB Query by Date in Java [closed]

2 Answers 2

Comments

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Linked

Related