如何使用pymongo获取基于起始日期和截止日期的文档？

Question

我有一个大型mongodb集合，其中的“日期”字段为：

'date': '2020-06-11 10:05:03.718804'

我想查找从到日期之间的文档

Mongo中的数据：（样本采集）

{
"_id":"001",
"color":"Blue",
"status":"available",
"date": "2020-06-11 10:05:03.718804"
},
{
"_id":"002",
"color":"Gold",
"status":"available",
"date": "2020-06-12 11:25:03.714804"
},
{
"_id":"003",
"color":"Violet",
"status":"available",
"date": "2020-06-13 11:25:03.714804"
},
{
"_id":"004",
"color":"White",
"status":"available",
"date": "2020-06-14 11:44:23.618704"
}

Pymongo

from datetime import datetime
from_date = "2020-06-11 10:05:03.718804"
to_date = "2020-06-13 11:44:23.618704"
details = db.collection.find({date: {$gt: from_date, $lt:to_date}})
print(details)

输出：应列出从日期到日期之间的数据

面临错误：无效令牌，$gt和$lt无效

如何根据日期条件查找文档

提前谢谢

Answer 1

您可以使用ISODate将字符串转换为可比较的日期

from_date = "2020-06-11 10:05:03.718804"
to_date = "2020-06-13 11:44:23.618704"
details = db.collection.find({"date": { $gte: ISODate(from_date), $lt: ISODate(to_date)}})
print(details)