In this tutorial, we will see how to use whereYear query in laravel. The whereYear method may be used to compare a column's value against a specifice date.
Given below are examples for whereYear query in laravel.
Example 1:
/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
$users = User::whereYear('created_at', '=', '2020')
->get();
dd($users);
}
Example 2:
/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
$users = User::whereYear('created_at', '>=', '2020')
->get();
dd($users);
}
Example 3:
/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
$users = User::whereYear('created_at', '<=', '2020')
->get();
dd($users);
}
Example 4:
/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
$users = DB::table('users')
->whereYear('created_at', '=', '2020')
->get();
dd($users);
}
I hope this example helps you.