mongo 时间格式化查询,Mongodb：基于ISODate格式的时间查询

最新推荐文章于 2024-07-29 03:48:02 发布

黯羽轻扬

最新推荐文章于 2024-07-29 03:48:02 发布

阅读量1.1k

点赞数

文章标签： mongo 时间格式化查询

本文探讨如何在MongoDB中查询日期字段'YYYY-MM-DDT'位于04:00到08:00之间的文档，不考虑具体日期。通过使用聚合框架和$redact操作符，可以实现这个查询。示例展示了如何筛选出'小时'在4到8之间的文档。

摘要由CSDN通过智能技术生成

Suppose the sample documents in Mongodb database are as follows:

{ "date" : ISODate("2015-11-09T05:58:19.474Z") }

{ "date" : ISODate("2014-10-25T07:30:00.241Z") }

{ "date" : ISODate("2015-11-30T15:24:00.251Z") }

{ "date" : ISODate("2012-01-10T18:36:00.101Z") }

Expected:

{ "date" : ISODate("2015-11-09T05:58:19.474Z") }

{ "date" : ISODate("2014-10-25T07:30:00.241Z") }

Iam interested in finding the documents whose time in "date" field is between 04:00 and 08:00 irrespective of day,month and year. Indirectly query has to match any "YYYY-MM-DDT" in date field.

My approach would be, query all the documents within presumed duration of dates from node and then for each document that matched the query, compare the "date&#