如何从MySQL数据库获取今天/昨天的数据?
问题描述:
我想从数据库中检索今天的数据,但是我不知道该怎么做.我实际上想从过去24小时之内获取数据,我只想获取今天的数据(因此基于实际服务器时间).
I would like to retrive a TODAY'S data from the database, but I don't know how to do it. I would actually want to get the data from NOT the past 24 hours, I just want today's data (so based on the actual server time).
我还想获取昨天的数据.有人可以帮我怎么做吗?
I would also like to get data which was yesterday. Can anyone help me how to do it?
示例代码:
"SELECT id FROM folk WHERE time = ???"
提前谢谢!
答
我认为您正在寻找:
"SELECT id FROM folk WHERE DATE(time) = CURDATE()"
时间必须是您表中的字段,其中包含对该行的引用.
time must be a field in you table that holds a reference to the row.
更新
要获取昨天的附加信息:
To get yesterdays additions:
"SELECT id FROM folk WHERE DATE(time) = CURDATE() - 1"
更新2
要获得本月所有新增内容:
To get all additions this month:
"SELECT id FROM folk
WHERE MONTH(time) = MONTH(NOW()) AND YEAR(time) = YEAR(NOW())"
参考: http://dev. mysql.com/doc/refman/5.5/en/date-and-time-functions.html