如何从今天获得30天 [英] how to get 30 days from Todays

问题描述

Select from x
    WHERE yid = rid
    AND (h.test1 <=todaysdate) AND (h.test1>= 30 days from today)

我如何在今天从今天起30天内写该行？取而代之的是，我从今天的日期开始输入日期或一个月。

How can I write that line 30 days from today in a query? Instead I put a date or a month from todays date.

推荐答案

在MySQL中，您可以编写：

In MySQL you can write:

SELECT * FROM x
WHERE yid=r=d 
      AND h.test1 <= todaysdate
      AND h.test1 >= ADDDATE(todaysdate, INTERVAL 31 DAY);

您是否仍然确定请求？

您不想吗？ （日期在今天之前或30天之后）：

Are you sure anyway of your request?
Don't you want instead (dates before today or after 30 days):

SELECT * FROM x
WHERE yid=r=d 
      AND (h.test1 <= todaysdate
      OR h.test1 >= ADDDATE(todaysdate, INTERVAL 31 DAY));

或（日期从今天到今天的30天之间）

or (dates between today and 30 days from today)

SELECT * FROM x
WHERE yid=r=d 
      AND h.test1 BETWEEN todaysdate AND ADDDATE(todaysdate, INTERVAL 31 DAY);

在用户评论后编辑：

在MS中您可以使用的SQL

EDITED after user comment:
In MS SQL you can use

SELECT * FROM x
WHERE yid=r=d 
      AND h.test1 BETWEEN todaysdate AND DATEADD(dd, 30, todaysdate);

或

SELECT * FROM x
WHERE yid=r=d 
      AND h.test1 BETWEEN DATEDIFF(dd, 30, todaysdate) AND todaysdate;

请注意（正如我在评论中已经告诉您的那样）@dbaseman为您提供了正确的语法增加天数。我的只是使用该语法的正确查询。

Note that (as I've already told you in my comment) @dbaseman gave you correct syntax for adding days. Mine is just the correct query using that syntax.

在用户评论后再次编辑：

SELECT * FROM x
WHERE yid=r=d 
      AND h.test1 BETWEEN DATEDIFF(dd, 30, NOW()) AND NOW();

这篇关于如何从今天获得30天的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！