php mysql 查询取得今天,昨天,过去N天,过去一个星期,一个月的记录
思路:把记录转换成日期,然后跟当天比较
例子:假设有如下表格[tb]:tbfeeid | fee_amount | createtime
$em = 0;
//今天
$sql= "select * from tb where to_days(createtime) = to_days(now()) ";
if($em==1)
{
//昨天
$sql = "select * from tb where (TO_DAYS( NOW( ) ) - TO_DAYS( createtime )) =1 ";
}
else if ($em==2)
{
//7天
$sql= " select * from tb where(TO_DAYS( NOW( ) ) - TO_DAYS( createtime )) <=7 ";
}
else if ($em==3)
{
//1个月
$sql= " select * from tb where (TO_DAYS( NOW( ) ) - TO_DAYS( createtime )) <=30 ";
}
//同样道理,3个月,半年,1年。。。