mysql查询今天、昨天、7天、近30天、本月、上一月 数据

admin

1. // 获取今天的博客
   
2. Db::table('think_blog') ->whereTime('create_time', 'today')->select();
   
3. // 获取昨天的博客
   
4. Db::table('think_blog')->whereTime('create_time', 'yesterday')->select();
   
5. // 获取本周的博客
   
6. Db::table('think_blog')->whereTime('create_time', 'week')->select();
   
7. // 获取上周的博客
   
8. Db::table('think_blog')->whereTime('create_time', 'last week')->select();
   
9. // 获取本月的博客
   
10. Db::table('think_blog')->whereTime('create_time', 'month')->select();
    
11. // 获取上月的博客
    
12. Db::table('think_blog')->whereTime('create_time', 'last month')->select();
    
13. // 获取今年的博客
    
14. Db::table('think_blog')->whereTime('create_time', 'year')->select();
    
15. // 获取去年的博客
    
16. Db::table('think_blog')->whereTime('create_time', 'last year')->select();

复制代码