Exception: can’t convert from BSON type EOO to Date

by

You likely have one or more docs with a created_at value that’s not a BSON Date and you’ll need to fix that by converting those values to Date or removing them.

You can find those docs with a $not query that uses the $type operator like:

db.snippets.find({created_at: {$not: {$type: 9}}})

If the created_at values are date strings, you can find the docs that need updating and then update them in the shell using code like:

db.snippets.find({created_at: {$not: {$type: 9}}}).forEach(function(doc) {
    // Convert created_at to a Date 
    doc.created_at = new Date(doc.created_at);
    db.snippets.save(doc);
})

More Related Contents:

  1. Does MongoDB’s $in clause guarantee order
  2. Moongoose aggregate $match does not match id’s
  3. How to return just the nested documents of an array from all documents
  4. MongoDB: Calculate dwell time between every status value change
  5. MongoDB: how to parse date in 3.6 mongoDb version?
  6. convert iso date to timestamp in mongo query
  7. Mongodb aggregation $group, restrict length of array
  8. Find documents whose array field contains at least n elements of a given array
  9. $project in $lookup mongodb
  10. Mongodb, aggregate query with $lookup
  11. Retrieve only the queried element in an object array in MongoDB collection
  12. Update MongoDB field using value of another field
  13. MongoDB: Combine data from multiple collections into one..how?
  14. Node.js Mongoose.js string to ObjectId function
  15. MongoDB SELECT COUNT GROUP BY
  16. Multiple join conditions using the $lookup operator
  17. Mongoose — Force collection name
  18. MongoError: The ‘cursor’ option is required, except for aggregate with the explain argument
  19. Average Aggregation Queries in Meteor
  20. Unhandled promise rejection: Error: URL malformed, cannot be parsed
  21. Find duplicate records in MongoDB
  22. $unwind empty array
  23. How to sum every fields in a sub document of MongoDB?
  24. How to return Mongoose results from the find method?
  25. Delete a key from a MongoDB document using Mongoose
  26. Using $slice operator to get last element of array
  27. Mongoose.js instance.save() callback not firing
  28. MongoDB count() versus countDocuments()
  29. Group by Date with Local Time Zone in MongoDB
  30. Group and count by month

Leave a Comment