本文介绍了怎么做:“今天和今天之间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"?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!