Breaking News: Grepper is joining You.com. Read the official announcement!

mongodb time gap between two timestamps

Adorable Addax answered on July 26, 2021 Popularity 5/10 Helpfulness 1/10

answer mongodb time gap between two timestamps

related mongodb time gap between two timestamps

mongodb time gap between two timestamps

Comment

// { _id: 1, start: ISODate("2015-08-24T00:00:00Z"), end: ISODate("2015-08-24T07:00:00Z") }
// { _id: 2, start: ISODate("2015-08-24T20:00:00Z"), end: ISODate("2015-08-25T01:00:00Z") }
db.collection.aggregate([
  { $project:
    { duration:
      { $dateDiff: { startDate: "$start", endDate: "$end", unit: "hour" } }
    }
  }
])
// { "_id" : 1, "duration" : 7 }
// { "_id" : 2, "duration" : 5 }

Popularity 5/10 Helpfulness 1/10 Language whatever

Source: stackoverflow.com

Tags: between mongodb time whatever

Link to this answer
Share Copy Link

Contributed on Jul 26 2021

Adorable Addax

0 Answers Avg Quality 2/10

Closely Related Answers

mongodb time gap between two timestamps

Comment

db.collectionname.aggregate([
  {$project: {
      duration: {$divide: [{$subtract: ["$endtime", "$starttime"]}, 3600000]}
  }}
])

Popularity 5/10 Helpfulness 1/10 Language whatever

Source: stackoverflow.com

Tags: mongodb time whatever between

Link to this answer
Share Copy Link

Contributed on Jul 26 2021

Adorable Addax

0 Answers Avg Quality 2/10

mongodb time gap between two timestamps

Contents

More Related Answers

mongodb time gap between two timestamps

Closely Related Answers

mongodb time gap between two timestamps

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.