php - 在 Laravel 中，whereBetween 与 Carbon 的配合不佳

Question

我想查询2016-01-10创建的用户。所以在 Laravel 5.1 中的代码是这样的(created_at 是时间戳):

$day1 = new Carbon();
$day1->year = 2016;
$day1->month = 1;
$day1->day = 10;

$day2 = new Carbon();
$day2->year = 2016;
$day2->month = 1;
$day2->day = 11;

User::whereBetween('created_at', [$day1->startOfDay(), $day2->startOfDay()])->get();

上面的代码工作正常。但是这种正常的方式不会:

User::whereBetween('created_at', [$day1->startOfDay(), $day1->endOfDay()])->get();

我认为没有区别。

Answer 1

你不需要中间的:

$myDate = new Carbon('2016-01-10');
User::whereDate('created_at', '=', $myDate->format('Y-m-d'))->get();