Laravel 5.4:选择仅在2天内的记录

你应该这样做:

->whereDate('created_at', '>', Carbon::today()->subDays( 2 ))
->whereDate('created_at', '!=', Carbon::today());

这将在今天排除。

如果您更喜欢原始查询,那么可以执行以下操作:

->whereBetween(\DB::raw("DATE(`created_at`)"), [ Carbon::today()->subDays(2), Carbon::today()->subDays(1) ]);

注意:今天使用是因为它使代码看起来更具表现力,但是 now 也可以。

请执行以下操作:

->whereDate( 'created_at', '>=', Carbon::today()->subDays( 2 ) )
->whereDate( 'created_at', '<', Carbon::today() )

加上这个,可能对你有用

->whereDate( 'created_at', '>', Carbon::today()->subDays( 2 ) )
->whereDate( 'created_at', '!=', Carbon::today())

尝试 ->WhereDate(“创建时间”、“<”、Carbon::Now()->添加日期(2))

你可以使用 whereBetween https://laravel.com/docs/5.6/queries#where-clauses

->whereBetween('created_at', [now()->subDays(2)->startOfDay(), now()->endOfDay()]) 

——

您还可以使用多个 where 条款:

->where('created_at', '>', now()->subDays(2)->startOfDay())
->where('created_at', '<', now()->endOfDay())

——

您也可以使用 whereDate

->whereDate('created_at', '>', now()->subDays(2)->startOfDay())
->whereDate('created_at', '<', now()->endOfDay())

——

碳文档: https://carbon.nesbot.com/docs/