sql语名查询"今天","昨天","本周","本月"数据方法！

最新推荐文章于 2022-02-07 10:47:57 发布

网游草

最新推荐文章于 2022-02-07 10:47:57 发布

阅读量1.5k

点赞数

分类专栏： SQL 文章标签： sql date

SQL 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

switch ($datetype) {
                case 1://今天
                    $sql .= " AND `lastupdate` BETWEEN '".(strtotime(date('Y-m-d')." 00:00:00"))."' AND '".(strtotime(date('Y-m-d')." 23:59:59"))."'";
                    break;
                    
                case 2://昨天
                    $sql .= " AND `lastupdate` BETWEEN '".(strtotime(date('Y-m-d')." 00:00:00")-86400)."' AND '".(strtotime(date('Y-m-d')." 23:59:59")-86400)."'";
                    break;
                    
                case 3://本周
                    $week = date('w');
                    if (empty($week)) $week = 7;
                    $sql .= " AND `lastupdate` BETWEEN '".(strtotime(date('Y-m-d')." 23:59:59")-86400*$week)."' AND '".(strtotime(date('Y-m-d')." 23:59:59")+(86400*(7-$week)))."'";
                    break;
                
                case 4://本月
                    $day = date('t');
                    $sql .= " AND `lastupdate` BETWEEN '".strtotime(date('Y-m-1')." 00:00:00")."' AND '".strtotime(date('Y-m-'.$day)." 23:59:59")."'";
                    break;
                    
                case 5://所有
                    $sql .= " AND `lastupdate` <= '".SYS_TIME."'";
                    break;
            }