$rows = Registrant::select(DB::raw('count(*) as number, created_at'))
->whereBetween( DB::raw('date(created_at)'), [$fromDate, $tillDate] )
->groupBy(DB::raw('date(created_at)'))
->get();
上面的查询给了我以下结果:
[{"number":4,"created_at":"2017-11-08 17:57:37"}]
哪个非常正确,除了我只想在没有时间的情况下呈现日期(17:57:37)?如何删除获取此内容的时间:
[{"number":4,"created_at":"2017-11-08"}]
只需替换
DB::raw('count(*) as number, created_at')
跟
DB::raw('count(*) as number, DATE(created_at)')