N days Difference in two date fields

Hi guys,

Need help in Eloquent Query.

Have two Date fields:

delivery_date - format('Y-m-d') created_at created by laravel

Need query to get rows, which have the difference between this dates more/less than n days.

P.S. Using pagination, so can't get it done using php.

Level 6

$diff = MyData::select(DB::raw('DATEDIFF(delivery_date,created_at) as days'))->paginate(10);

1 like

Level 122

use DATEDIFF as per @Cinek suggestion, but use it in a where statement not a select

1 like

Best Answer

Level 6

$days = 200;
        $data= MyData::whereRaw('DATEDIFF(updated_at,created_at) < ?')
            ->setBindings([$days])
            ->get();

Level 3

@Cinek @Snapey Thanks both of you

Please or to participate in this conversation.