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.