Mongodb 字符串转Date 计算时间间隔

$dateFromString: {
  dateString: '2019-07-22',
  timezone: 'Asia/Shanghai'
}}

确定好字符串和时区即可

计算时间间隔

$subtract:[
	{$dateFromString: {
			dateString: '2019-07-22',
			timezone: 'Asia/Shanghai'
		}}, 
		{$dateFromString: {
			dateString: '$time',
			timezone: 'Asia/Shanghai'
		}}
		
	]
}

计算间隔多少天

db.col.aggregate([{
    $project: {
        title: 2,
        likes: 1,
        startDay: "$time",
        endDay: new ISODate('2019-07-22 00:00:00'),
        days: {
            $floor:{
                $divide:[
                    {$subtract:[
                        {$dateFromString: {
                                dateString: '2019-07-22',
                                timezone: 'Asia/Shanghai'
                            }}, 
                            {$dateFromString: {
                                dateString: '$time',
                                timezone: 'Asia/Shanghai'
                            }}
                            
                        ]
                    }, 60 * 60 * 24 * 1000
                ]
             }
         }
    }
}])

时间相减然后得到时间戳，除以60 * 60 * 24 * 1000得到天数，最后取整即可

转载于:https://my.oschina.net/xiaohuai4869/blog/3077527