Get today records in Laravel

Updated at 18-Oct-2021, By samar

Get today records in Laravel

We will use programming in this lesson to attempt to solve the "Get today records in Laravel".

You can get today records using whereDate() with Carbon and you can also use whereRaw() method in Laravel. It will return all the records from tables which is created at today in Laravel.
  • Get records which created at today using whereDate() with Carbon in Laravel 8

    $users = App\Models\User::whereDate('created_at', '=', \Carbon\Carbon::today()->format('Y-m-d'))->get();
    return $users;
    

    Output:

    [{"id":19,"name":"w3codegenerator.com","email":"[email protected]","email_verified_at":"2021-09-24T03:36:45.000000Z",
    "created_at":"2021-10-17T03:36:45.000000Z","updated_at":"2021-09-24T03:36:45.000000Z"}]

    This code snippet will helps you to get the records from table which is created at today. Here we have get all the users records which is created at today using whereDate() method with Carbon in Laravel. You can change model path as per your requirements in laravel 8 (App\Models\User) and in laravel version < 8 (App\User).

  • Get today records using whereRaw() in Laravel 8

    $users = App\Models\User::select(DB::raw('*'))->whereRaw('Date(created_at) = CURDATE()')->get();
    return $users;
    

    Output:

    [{"id":19,"name":"w3codegenerator.com","email":"[email protected]","email_verified_at":"2021-09-24T03:36:45.000000Z",
    "created_at":"2021-10-17T03:36:45.000000Z","updated_at":"2021-09-24T03:36:45.000000Z"}]

    This code snippet will helps you to get the records from table which is created at today. Here we have get all the users records which is created at today using whereRaw() method.

Back to code snippet queries related laravel