Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- db.events.find({'end': {'$gte': datetime.utcnow() - timedelta(days=3)})
- db.events.aggregate([
- { '$match':
- { 'end':
- { '$gte': datetime.utcnow() - timedelta(days=3) }
- }
- },
- { '$project':
- {
- 'timeDelta': {
- '$subtract': ['$end', datetime.utcnow()]
- }
- }
- },
- { '$project':
- {
- 'absTimeDelta' : {
- '$cond' : [
- { '$lte': ['$timeDelta', 0] },
- { '$multiply' : ['$timeDelta', -1 ] },
- '$timeDelta'
- ]
- }
- }
- },
- { '$sort':
- {
- 'absTimeDelta' : 1
- }
- }
- ])
Add Comment
Please, Sign In to add comment