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)
-
{
-
-
$sql= " select * from tb where(TO_DAYS( NOW( ) ) - TO_DAYS( createtime )) <=7 ";
-
}
-
else if ($em==3)
-
{
-
-
$sql= " select * from tb where (TO_DAYS( NOW( ) ) - TO_DAYS( createtime )) <=30 ";
-
}
-
-
