mongodb + java + iso date search

Question

In my mongo db database i have column like this.

"created_on" : ISODate("2014-07-02T01:38:48.713Z");

In order to to search this column am giving the following query:

db.XYZ.find({ "created_on" : ISODate("2014-07-02T01:38:48.713Z")})

Now i want to use java for retrieving this data from database: My query is like:

 DateTime dateTime = new DateTime( "2014-07-02T01:38:48.713Z" );
 BasicDBObject query1 = new BasicDBObject("created_on", dateTime);
 DBCursor cursor = table.find(query);

but am not getting anything query is returning 0 rows??

Any body please help how to set iso date from java.

Zarathustra · Accepted Answer · 2014-07-07 15:24:50Z

1

The mongodb driver does not work with DateTime currently. You have to use java.util.Date

answered Jul 7, 2014 at 15:24

Zarathustra

2,9634 gold badges36 silver badges63 bronze badges

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

Collectives™ on Stack Overflow

mongodb + java + iso date search

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related