how can i fetch records between two specific hours in laravel

Viewed 26

I have two working shift first from 8:00 Am to 17:00:00PM second From 17:00:00PM to 8:00AM next day, How can I fetch records between two hours by carbon {{\App\Models\PolicyDetail::wheredate('second_scale', \Carbon\Carbon::today())->count()}}

1 Answers

$from = date('2018-01-01 05:00:00'); $to = date('2018-05-02 09:00:00');

User::whereBetween('applied_on', [$from, $to])->get();

Related