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

$q->whereDate('created_at', '=', date('Y-m-d'));

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

$q->where('created_at', '>=', date('Y-m-d').' 00:00:00'));

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