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.

Answers 2
  • 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;
    
    0

    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;
    
    0

    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