select * from tableName where (to_days(now()) <= (to_days(insetDate)+7))
显示一周之内的记录信息。
select * from online_product_info where datediff(createDate,'2010-1-27')=0 日期相等判断
select * from tableName where (to_days(now()) <= (to_days(insetDate)+7))
显示一周之内的记录信息。
select * from online_product_info where datediff(createDate,'2010-1-27')=0 日期相等判断