mysql - Laravel whereBetween 不起作用。表明？

Question

这个问题已经有答案了:

Order of from and to values in SQL Between (3 个回答)

已关闭 4 年前。

我正在尝试从 leads 获取上周的数据表但是当我使用whereBetween时有两个日期没有找到数据，如果我使用 toSql()表明 ？ ？

查询是

    select `lead_type`, `email`, `first_name`, `last_name`, `phone_number`, `job_title`, `company_name`, `website`, `time_note`, `update_date` from `leads` where `created_at` between ? and ? 

但应该是

    select `lead_type`, `email`, `first_name`, `last_name`, `phone_number`, `job_title`, `company_name`, `website`, `time_note`, `update_date` from `leads` where `created_at` between 2019-06-06 and 2019-05-30

这是 Laravel 代码

    $current=  Carbon::today();
    $start_date = Carbon::today()->toDateString();
    $end_date = $current->subDays(7)->toDateString();
    $leads = Leads::select($excel_head)->whereBetween('created_at', [$end_date,$start_date ])->toSql();
    dd($leads);

Answer 1

您已将开始日期和结束日期倒置。

whereBetween('created_at', [$end_date, $start_date])

应该变成

whereBetween('created_at', [$start_date, $end_date])

否则，您的查询基本上是这样做的:

created_at>='2019-06-06' AND created_at<='2019-05-30'

这不可能是真的。