Laravel Eloquent whereDay() Query Example

Hi Guys,

In this example,I will learn you how to use whereDay query in laravel.you can easy and simply use whereDay query in laravel.

whereDay() through we can get only specific day records from your timestamps column, like if you want to get every month 10th day records, you can see bellow example with output.

Example 1:

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

    
}

Example 2:

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

    
}

Example 3:

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

    
}

Example 4:

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

    
}

It will help you...