Jongo ISODate related issue

38 views
Skip to first unread message

Roodies MM

unread,
Apr 11, 2017, 3:08:31 AM4/11/17
to Jongo
Not getting the desired resultset for the selected date.

Date is in Joda timestamp

stDate  -> Start Date. Example 2017-04-06T07:00:00.000+05:30
edDate -> End Date. Example 2017-04-07T07:00:00.000+05:30

JAVA
hourly.aggregate("{$match : {'Timestamp' : {'$gte' : { '$date' : '"+ stDate +"'}, '$lte' : { '$date' : '" + edDate +"'}}}}").as(someclass.class)

Please help fix this issue.

Roodies MM

unread,
Apr 11, 2017, 3:16:53 AM4/11/17
to Jongo
Is the issue is because of date getting converted to string when it is framed ???
Reply all
Reply to author
Forward
0 new messages