How do I convert a property in MongoDB from text to date type?

by

This code should do it:

> var cursor = db.ClockTime.find()
> while (cursor.hasNext()) {
... var doc = cursor.next();
... db.ClockTime.update({_id : doc._id}, {$set : {ClockInTime : new Date(doc.ClockInTime)}})
... }

More Related Contents:

  1. MongoDB: Combine data from multiple collections into one..how?
  2. MongoDB: Is it possible to make a case-insensitive query?
  3. MongoDB: count the number of items in an array
  4. How to remove a field completely from a MongoDB document?
  5. Multiple join conditions using the $lookup operator
  6. Aggregate $lookup Total size of documents in matching pipeline exceeds maximum document size
  7. Understanding MongoDB BSON Document size limit
  8. MongoDB – admin user not authorized
  9. How can I run MongoDB as a Windows service?
  10. How do I search for an object by its ObjectId in the mongo console?
  11. MongoDB password with “@” in it
  12. exclude fields in $lookup aggregation
  13. Mongo how to $lookup with DBRef
  14. Add some kind of row number to a mongodb aggregate command / pipeline
  15. How to enforce foreign keys in NoSql databases (MongoDB)?
  16. How do you query for “is not null” in Mongo?
  17. MongoDB select count(distinct x) on an indexed column – count unique results for large data sets
  18. MongoDB sort documents by array elements
  19. MongoDB won’t start after server crash
  20. Does Mongoose support the Mongodb `findAndModify` method?
  21. How does sorting with an index work in MongoDB?
  22. How to use dot in field name?
  23. Docker: change folder where to store docker volumes
  24. What is the maximum number of parameters passed to $in query in MongoDB?
  25. How to organise a many to many relationship in MongoDB
  26. Mongodb aggregation pipeline how to limit a group push
  27. Insert json file into mongodb
  28. Clone a collection in MongoDB
  29. Return actual type of a field in MongoDB
  30. Sort nested array of objects

Leave a Comment