Convert date from milliseconds to ISODate object

by

Actually, it is possible, the trick is to add your milliseconds time to a zero-milliseconds Date() object using syntax similar to:

dt : {$add: [new Date(0), "$time"]}

I modified your aggregation from above to produce the result:

db.events.aggregate(
    {
        $project : {
            _id : "$_id",
            dt : {$add: [new Date(0), "$time"]}
        }
    },
    { 
        $project : {
            _id : "$_id",
            date : { 
                hour : {$hour : "$dt"} 
            }
        }
    }
);

The result is (with one entry of your sample data):

{
  "result": [
    {
      "_id": ObjectId("532828ac338ed9c33aa8eca7"),
      "date": {
        "hour": 11
      }
    }
  ],
  "ok": 1
}

More Related Contents:

  1. Aggregation filter after $lookup
  2. Convert ObjectID (Mongodb) to String in JavaScript
  3. Group by Date with Local Time Zone in MongoDB
  4. access MONGODB on remote server [closed]
  5. Updating a Nested Array with MongoDB
  6. Issue in returning data retrieved from DB queries called in the loop
  7. How do I update/upsert a document in Mongoose?
  8. Understanding Meteor Publish / Subscribe
  9. How do you put an image file in a json object?
  10. Referencing another schema in Mongoose
  11. How do the JavaScript relational comparison operators coerce types?
  12. Typescript: deep keyof of a nested object, with related type
  13. UnhandledPromiseRejectionWarning: MongooseServerSelectionError
  14. MongoDB select where in array of _id?
  15. Is true == 1 and false == 0 in JavaScript?
  16. Inserting and Querying Date with MongoDB and Nodejs
  17. What is the right way to make a synchronous MongoDB query in Node.js?
  18. How to change all the array elements in a mongodb document to a certain value? [duplicate]
  19. Cannot find module ‘../build/Release/bson’] code: ‘MODULE_NOT_FOUND’ } js-bson: Failed to load c++ bson extension, using pure JS version
  20. Server Discovery And Monitoring engine is deprecated
  21. Mongoose stopped accepting callbacks for some of its functions
  22. MongooseServerSelectionError: connect ECONNREFUSED ::1:27017
  23. Handlebars: Access has been denied to resolve the property “from” because it is not an “own property” of its parent
  24. Javascript: avoid exceptions for string to integer or float typecast conversion with null or undefined variables?
  25. How to convert a string to ObjectId in nodejs mongodb native driver?
  26. Loop through all Mongo collections and execute query
  27. JavaScript NoSQL Injection prevention in MongoDB
  28. Meteor publish/subscribe strategies for unique client-side collections
  29. MongooseError: Model.findOne() no longer accepts a callback at Function
  30. Why an empty Array type-converts to zero? +[]

Leave a Comment