I want to get records that are joined between this date period (2022-02-15, 2022-08-20)个
$users = User::whereDate('start_at', '>=', $startDate)
->whereDate('end_at', '<=', $endDate)
->get();
I want to get records that are joined between this date period (2022-02-15, 2022-08-20)个
$users = User::whereDate('start_at', '>=', $startDate)
->whereDate('end_at', '<=', $endDate)
->get();
$_start_date = '2022-02-15';
$_end_date ='2022-08-20';
$users = User::where(function ($query) use ($_start_date, $_end_date) {
$query->where(function ($query) use ($_start_date, $_end_date) {
$query->whereRaw("start_date >= date('$_start_date')")
->whereRaw("end_date <= date('$_end_date')");
})
->orwhere(function ($query) use ($_start_date, $_end_date) {
$query->whereRaw("start_date <= date('$_start_date')")
->whereRaw("end_date >= date('$_end_date')");
});
})->get();
try above code这也将在开始日期和结束日期之间返回,例如下面
$_start_date = '2022-02-18';
$_end_date ='2022-08-20';
也适用于以下日期,例如
$_start_date = '2022-02-16';
$_end_date ='2022-08-18';