In this tutorial, we will see how to use wheredate query in laravel. The whereDate method may be used to compare a column's value against a specifice date.

Given below are examples for  wheredate query in laravel.



Example 1:

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    $users = User::whereDate('created_at', '=', '2020-07-23')
                ->get();
    dd($users);
    
}



Example 2:

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    $users = User::whereDate('created_at', '>=', '2020-07-23')
                ->get();
    dd($users);
    
}



Example 3:

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    $users = User::whereDate('created_at', '<=', '2020-07-23')
                ->get();
    dd($users);
    
}



Example 4:

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    $users = DB::table('users')
                ->whereDate('created_at', '=', '2020-07-23')
                ->get();
    dd($users);
    
}


I hope this example helps you.