How to retrieve data from the latest date in laravel?

Question

In mySql, I can perform to data of latest date as follows:

select * from tbl where date = 'select max(date) from tbl';

But I don't know how to do this is laravel? How to do it?

Answer 1

use orderbBy():

TblModel::orderBy('date','DESC')->first();

Or

DB::table('tbl')->orderBy('date', 'DESC')->first();

Update:

TblModel::where('date', TblModel::max('date'))->orderBy('date','desc')->get();

Answer 2

You can use latest():

DB::table('tbl')->latest()->first(); // considers created_at field by default.

Or

DB::table('items')->latest('date')->first(); //specify your own column

---

Under the hood:

latest() will orderBy with the column you provide in descending order where the default column will be created_at.

//Illuminate\Database\Query\Builder
public function latest($column = 'created_at')
{
    return $this->orderBy($column, 'desc');
}