如何在Laravel中获取日期列与当前日期的日期差异？

Question

我想要添加所有的loan_amort值，其中schedule is <= 30 days when schedule减去了当前日期。我该怎么做呢？以下是我的示例代码。我搞不懂whereRaw部分。请帮帮忙。谢谢。

$totalDues = Amortization::select('loan_type', \DB::raw('SUM(loan_amortization) as total_current'))
                            ->where('payment_status',0)
                            ->whereRaw('date_diff(schedule,now()) <= 30')
                            ->groupBy('loan_type')
                            ->orderBy('loan_type')
                            ->get();

Answer 1

with td  as
   ( select  generate_series( now(), now()+interval '35 day', '1 day')  schedule )
select date_part('day',schedule-now()) diff;

我想对你来说这意味着

->whereRaw('date_part(''day'',schedule-now() <= 30')