Hi MongoDB users
How to retrieve ISO "CREATE_DATE" : ISODate("2002-02-21T05:30:00.000+0530"), date from from mongoDB using JAVA .
My date from the application i am giving as String format ("2002-02-21") and tired converting in to the above format by
DateFormat df = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.000'Z'");
and while invoking the query is formed as below.
{ "CREATE_DATE" : { "$gte" : "2013-11-17T00:00:00.000Z" , "$lt" : "2015-11-17T00:00:00.000Z"} , "QUEUE_ID" : 4576}
But still unable to search in mongo DB giving 0 output , Can anyone please help me to resolve the issue . how to exactly convert the date given in String to ISODate format which mognoDB identify.
Regards
Rakesh