复制代码 代码如下:
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')
非时间戳日期格式归档(date_format格式化日期)
复制代码 代码如下:
select date_format(`post_date`,'%y%m%d') as pubtime, count(*) as cnt from wp_posts where `post_status`='publish' group by date_format(`post_date`,'%y%m%d') order by `id` desc
select date_format(`post_date`,'%y%m%d') as pubtime,date_format(`post_date`,'%m 月 %d 日') as shijian,count(*) as cnt from wp_posts where `post_status`='publish' group by date_format(`post_date`,'%y%m%d') order by `id` desc limit 0,7
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:)！