Date query with ISODate in mongodb doesn’t seem to work

by

Although $date is a part of MongoDB Extended JSON and that’s what you get as default with mongoexport, I don’t think you can really use it as a part of the query.

If try exact search with $date like below:

db.foo.find({dt: {"$date": "2012-01-01T15:00:00.000Z"}})

you’ll get the error:

error: { "$err" : "invalid operator: $date", "code" : 10068 }

Try this:

db.mycollection.find({
    "dt" : {"$gte": new Date("2013-10-01T00:00:00.000Z")}
})

or (following comments by @user3805045):

db.mycollection.find({
    "dt" : {"$gte": ISODate("2013-10-01T00:00:00.000Z")}
})

ISODate may be also required to compare dates without time (noted by @MattMolnar).

According to Data Types in the mongo Shell both should be equivalent:

The mongo shell provides various methods to return the date, either as a string or as a Date object:

  • Date() method which returns the current date as a string.
  • new Date() constructor which returns a Date object using the ISODate() wrapper.
  • ISODate() constructor which returns a Date object using the ISODate() wrapper.

and using ISODate should still return a Date object.

{"$date": "ISO-8601 string"} can be used when strict JSON representation is required. One possible example is Hadoop connector.

More Related Contents:

  1. Mongoimport of JSON file
  2. Import more than 1 json file using mongoimport
  3. Creating BSON object from JSON string
  4. Convert MongoDB BsonDocument to valid JSON in C#
  5. Dump Mongo Collection into JSON format
  6. Setting Access-Control-Allow-Origin in ASP.Net MVC – simplest possible method
  7. Can JSON start with “[“?
  8. What JSON library to use in Scala? [closed]
  9. Parse JSON with R
  10. How to decode a property with type of JSON dictionary in Swift [45] decodable protocol
  11. Decoding generic JSON objects to one of many formats
  12. How do I exclude fields with Jackson not using annotations?
  13. Returning Null JSON Throwing Type Mismatch Error in VBA
  14. How to create public/private user profile with Firebase security rules?
  15. Read JSON data in a shell script [duplicate]
  16. How to turn json to case class when case class has only one field
  17. Coldfusion 10 returnformat=”JSON” adding characters
  18. Iterate a Json Object with ngFor
  19. How to convert a JSON object stream into an array with jq
  20. Error in searching data using listview in flutter
  21. Serialize in JSON a base64 encoded data
  22. Parsing JSON feed automatically into MS Access
  23. Accessing a request’s body using classic ASP?
  24. Collect Recursive JSON Keys In Postgres
  25. Can a JSON value contain a multiline string
  26. Is there an API call for changing user password on keycloak?
  27. Handle JSON Object in XMLHttp response in Excel VBA Code
  28. JSON single value parsing
  29. Very large HTTP request vs many small requests
  30. How to extract all the keys in a JSON object with BigQuery

Leave a Comment