Get today records 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":"w3codegenerat[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":"w3codegenerat[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