Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MongoDB + nodejs : how to query ISODate fields?

I am using nodejs with the node-mongodb-native driver (http://mongodb.github.io/node-mongodb-native/).

I have documents with a date property stored as ISODate type.

Through nodejs, I am using this query:

db.collection("log").find({     localHitDate: {              '$gte': '2013-12-12T16:00:00.000Z',             '$lt': '2013-12-12T18:00:00.000Z'      } }) 

It returns nothing. To make it work I need to do the following instead:

db.collection("log").find({     localHitDate: {             '$gte': ISODate('2013-12-12T16:00:00.000Z'),             '$lt': ISODate('2013-12-12T18:00:00.000Z')     } }) 

But ISODate is not recognized in my nodejs code.

So how can I make a query against mongo date fields through my nodejs program?

Thank you

like image 315
Fred Mériot Avatar asked Dec 13 '13 07:12

Fred Mériot


People also ask

What is ISODate in MongoDB?

You can specify a particular date by passing an ISO-8601 date string with a year within the inclusive range 0 through 9999 to the new Date() constructor or the ISODate() function. These functions accept the following formats: new Date("<YYYY-mm-dd>") returns the ISODate with the specified date.

Which function is used to update the student record of MongoDB via Nodejs?

Update Document You can update a record, or document as it is called in MongoDB, by using the updateOne() method.


1 Answers

You can use new Date('2013-12-12T16:00:00.000Z') in node.js;

new is a must, because Date() is already use to return date string.

ISODate is concepted in mongodb, you can use it in mongodb console, but it can be different for different programming language.

like image 102
damphat Avatar answered Sep 29 '22 18:09

damphat