xxxxxxxxxx
db.getCollection('My_Collection').aggregate([
{ $project: { dateDifference: { $subtract: [ "$startDate", "$endDate" ]}}}
])
xxxxxxxxxx
# Syntax
db.collection_name.find({
field_name: {
$gte: 'YYYY-MM-DD HH:mm:ss',
$lte: 'YYYY-MM-DD HH:mm:ss'
}
})
# Sample
db.logs.find({
created_at: {
$gte: '2022-01-01 00:00:00',
$lte: '2022-12-31 23:59:59'
}
})
xxxxxxxxxx
db.collection.aggregate([
{
$project: {
days: {
$dateDiff: {
startDate: "$start",
endDate: "$end",
unit: "day"
}
},
_id: 0
}
}
])
xxxxxxxxxx
db.sales.aggregate( [ { $project: { item: 1, dateDifference: { $subtract: [ "$$NOW", "$date" ] } } } ] )