php查询mysql数据库某一天或某个月

1.某个月

SELECT * FROM `table` WHERE FROM_UNIXTIME(add_time,'%Y-%m')='2020-07';


  $list = $this->model
                    ->where($where)
                    ->where('FROM_UNIXTIME(add_time,"%Y-%m")="'.$_GET['time'].'"')
                    ->order($sort, $order)
                    ->limit($offset, $limit)
                    ->select();

2.某一天

 SELECT * FROM `eb_user_bill` WHERE FROM_UNIXTIME(add_time,'%Y-%m-%d')='2020-07-03';


  $list = $this->model
                    ->where($where)
                    ->where('FROM_UNIXTIME(add_time,"%Y-%m-%d")="'.$_GET['time'].'"')
                    ->order($sort, $order)
                    ->limit($offset, $limit)
                    ->select();

另一种某一天

 //每日开始时间
                $begin_time = strtotime(date($_GET['time'].' 00:00:00'));
                //每日结束时间
                $end_time = strtotime(date($_GET['time'].' 23:59:59'));
                $total = $this->model
                    ->where($where)
                    ->where('add_time','>=',$begin_time)->where('add_time','<=',$end_time)
                    ->order($sort, $order)
                    ->count();