本文介绍了Mongodb查询特定月份|年份而不是日期的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

如何查询mongodb中的特定月份而不是日期范围,我需要一个月来列出当前月份的客户生日.

How can I query a specific month in mongodb, not date range, I need month to make a list of customer birthday for current month.

在SQL中将是这样的:

In SQL will be something like that:

SELECT * FROM customer WHERE MONTH(bday)='09'

现在我需要在mongodb中翻译它.注意:我的日期已经以MongoDate类型保存,我以前曾经很容易使用这种想法,但是现在我不容易找到如何做这个简单的事情.

Now I need to translate that in mongodb.Note: My dates are already saved in MongoDate type, I used this thinking that will be easy to work before but now I can't find easily how to do this simple thing.

推荐答案

您可以在 $month 投影运算符:

You can do that using aggregate with the $month projection operator:

db.customer.aggregate([
  {$project: {name: 1, month: {$month: '$bday'}}},
  {$match: {month: 9}}
]);

这篇关于Mongodb查询特定月份|年份而不是日期的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-05 19:33
查看更多