SELECT createTime FROM b_memberfavorite as m WHERE m.createTime BETWEEN DATE_SUB(now(),INTERVAL 7 DAY) and now()
本文出自 “白开水” 博客，谢绝转载！
Mysql XX 天之内
原文：http://4925054.blog.51cto.com/4915054/1718107
