PHP文章按日期(月日)SQL归档语句

复制代码 代码如下: select FROM_UNIXTIME(pubtime, ‘%Y-%m’) as pubtime, count(*) as cnt from articles group by FROM_UNIXTIME(pubtime, ‘%Y-%m’) PHP文章按日期(日)SQL归档 复制代码 代码如下: select FROM_UNIXTIME(pubtime, ‘%Y-%m-%d’) as pubtime, count(*) as cnt from articles group by FROM_UNIXTIME(pubtime, ‘%Y-%m-%d’) 非时间戳日期格式归