Laravel / Model / Where with date
Where with date
-
STEP
DATE_FORMAT
$data = Item::select("id","title","created_at") ->where(DB::raw("(DATE_FORMAT(created_at,'%Y-%m'))"),"2022-07") ->get(); whereDate
$products = Product::select("*") ->whereDate('created_at', '2023-09-03') ->get(); whereMonth
$products = Product::select("*") ->whereMonth('created_at', '09') ->get(); whereDay
$products = Product::select("*") ->whereDay('created_at', '03') ->get(); whereYear
$products = Product::select("*") ->whereYear('created_at', '2023') ->get();