Compare only month and year in db and fetch records

Don't know the format of your salary_date field, so let's assume that it is DD/MM/YYYY, you can create a Carbon instance out of it and then use Eloquent to find the match like this:

$date = Carbon::createFromFormat('d/m/Y', $request->salary_date);

$empsalaries = EmpSalary:: whereMonth('salary_date', $date->month)
    ->whereYear('salary_date', $date->year)
    ->get()

You should try like this:

$post = Mjblog::whereYear('created_at', '=', $year)
              ->whereMonth('created_at', '=', $month)
              ->get();

@nakov thank you for your response.

my salary_date format in db is 2019-08-28 year-month- date

i tried like this

 $date = Carbon::createFromFormat('Y-m-d', $request->salary_date);

but showing error

InvalidArgumentException
Data missing

whats the problem. in google some says add time also so i added H:m:s also but not working same error

@abdulbazith I think that your $request->salary_date is empty that's the reason why you get that error. So please check before you try to format it if you really send the salary_date from an input field in your view.

@nakov you are right.. small spelling mistake.. now it worked correctly