# 帝国CMS自定义列表如何按时间调用

*Published:* 2024-01-08
*Author:* 客服001

#### 温馨提醒

如果文章内容或图片资源失效，请留言反馈，我们会及时处理，谢谢

本文最后更新于2024年1月8日，已超过 180天没有更新



演示代码按8小时、24小时、7天、30天、365天时间调用，大家可以参照代码按实际情况修改3600\*72=72小时：

```
8小时内
select count(*) as total from [!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*720 
select * from [!db.pre!]ecms_news  where unix_timestamp(now())-newstime<3600*720 order by onclick desc


24小时内
select count(*) as total from [!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*2400
select * from [!db.pre!]ecms_news  where unix_timestamp(now())-newstime<3600*2400 order by onclick desc
 

7天内
select count(*) as total from [!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*7*24
select * from [!db.pre!]ecms_news  where unix_timestamp(now())-newstime<3600*7*24 order by onclick desc

 
一个月
select count(*) as total from [!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*30*24
select * from [!db.pre!]ecms_news  where unix_timestamp(now())-newstime<3600*30*24 order by onclick desc
 

一年
select count(*) as total from [!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*365*24
select * from [!db.pre!]ecms_news  where unix_timestamp(now())-newstime<3600*365*24 order by onclick desc
```