laravel ->where('orders.created_at BETWEEN '2020-09-22' AND '2020-09-23'') code example

Example 1: where('created_at', '=', date('Y-m-d'));

$q->whereDay('created_at', '=', date('d'));
$q->whereMonth('created_at', '=', date('m'));
$q->whereYear('created_at', '=', date('Y'));

Example 2: where('created_at', '=', date('Y-m-d'));

$q->where(DB::raw("DATE(created_at) = '".date('Y-m-d')."'"));