怎么做:“今天和今天之间7"? [英] How to do : "Between TODAY AND TODAY-7"?

问题描述

我需要找到当天创建的帐户，以及最近7天创建的帐户.

I need to find the account created for the current day, et for the last 7 days.

要找到今天的结果，它可以工作，我可以这样做:

To find my results for today, it works, and I do this :

SELECT * FROM `account` where DATE(created_at) = DATE(NOW())

但是我不知道如何获得最近7天的帐户.

But I don't know how to do to get the last 7days account.

我尝试了类似的方法，但是没有成功:

I tried something like this, but without success :

SELECT * FROM `account` where DATE(created_at) BETWEEN DATE(NOW()) AND DATE(NOW()-7)

你有个主意吗?

推荐答案

在mysql中:

SELECT * FROM `account` 
WHERE DATE(created_at) > (NOW() - INTERVAL 7 DAY)

这篇关于怎么做:“今天和今天之间7"?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！