mysql - Laravel where 子句与 DATEDIFF()

Question

我需要获取 DATEDDIFF() >30 和 <60 的所有记录。

我尝试过查询，但它不起作用。

如何获取符合条件的数据。

我的查询是，

 $cur_date=Carbon::now();


 $data=DB::table('mailbox_log as ml')
->leftjoin('registration as r','ml.reg_id','=','r.id')
->leftjoin('company as cmp','r.sociale_id','=','cmp.id')
->select('ml.*','r.id','r.g_id','r.num','cmp.name')
->where(DB::raw('DATEDIFF(ml.sent_pst_date, "%Y-%m-%d")'),$cur_date->format('Y-m-d'),'>','30')
->where(DB::raw('DATEDIFF(ml.sent_pst_date, "%Y-%m-%d")'),$cur_date->format('Y-m-d'),'<','60')
->get()->toArray();

Answer 1

尝试使用 Carbon addDays()

 $start_date = (Carbon::now())->addDays(30);
 $end_date = $start_date->addDays(30);

 $data=DB::table('mailbox_log as ml')
->leftjoin('registration as r','ml.reg_id','=','r.id')
->leftjoin('company as cmp','r.sociale_id','=','cmp.id')
->select('ml.*','r.id','r.g_id','r.num','cmp.name')
->where('ml.sent_pst_date','>',$start_date)
->where('ml.sent_pst_date','<',$end_date)
->get()->toArray();