WHERE 子句查找特定月份的所有记录 [英] WHERE Clause to find all records in a specific month

问题描述

我希望能够为存储过程提供一个月和一年的时间，并让它返回该月发生的所有事情，我该怎么做，因为我无法进行比较，因为有些月份有不同的天数等等?

I want to be able to give a stored procedure a Month and Year and have it return everything that happens in that month, how do I do this as I can't compare between as some months have different numbers of days etc?

这样做的最佳方法是什么?我可以要求按年和月比较吗?

What's the best way to do this? Can I just ask to compare based on the year and month?

谢谢.

推荐答案

我认为您正在寻找的功能是 MONTH(date).您可能还想使用 'YEAR'.

I think the function you're looking for is MONTH(date). You'll probably want to use 'YEAR' too.

假设您有一个名为 things 的表，如下所示:

Let's assume you have a table named things that looks something like this:

id happend_at
-- ----------------
1  2009-01-01 12:08
2  2009-02-01 12:00
3  2009-01-12 09:40
4  2009-01-29 17:55

假设您要执行以查找在 2009/01 月(2009 年 1 月)具有 happened_at 的所有记录.SQL 查询将是:

And let's say you want to execute to find all the records that have a happened_at during the month 2009/01 (January 2009). The SQL query would be:

SELECT id FROM things 
   WHERE MONTH(happened_at) = 1 AND YEAR(happened_at) = 2009

哪个会返回:

id
---
1
3
4

这篇关于WHERE 子句查找特定月份的所有记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！