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?

Alternatively, you can execute SQL as strings in Laravel with "DB::select(...)" — RoboBear, Feb 14 '18 at 05:18

Sapnesh Naik · Answer 1 · 2020-04-21T02:29:53.160

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');
}

Sohel0415 · Accepted Answer · 2018-10-10T08:17:13.437

11

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();

edited Oct 10 '18 at 08:17

answered Feb 14 '18 at 05:17

Sohel0415

9,523
21
30

but it will only fetch one record. What if on same date and time there are multiple records? How can you tackle that? – Sizzling Code Oct 09 '18 at 13:42
@SizzlingCode use `->get()` instead of using `->first()` – Sohel0415 Oct 10 '18 at 05:24
No, It will list everything in date descending order, what i meant for last datetime if there are multiple records, only for that specific last datetime how you get multiple records? – Sizzling Code Oct 10 '18 at 05:46
@SizzlingCode thanks for noticing, see my updated code – Sohel0415 Oct 10 '18 at 08:15

score 5 · Answer 3 · answered Feb 14 '18 at 05:36

5

You can also use an Eloquent here for your query

TableModel::latest()->first(); // returns the latest inserted record

TableModel::oldest()->first(); // returns the first ever inserted record from your table

answered Feb 14 '18 at 05:36

Dexter Bengil

5,995
6
35
54

patriziotomato · Answer 4 · 2018-02-14T08:06:25.363

-3

This is well documented here:

https://laravel.com/docs/5.6/eloquent#retrieving-single-models

You may also use the count, sum, max, and other aggregate methods provided by the query builder. These methods return the appropriate scalar value instead of a full model instance:

Examples:

$max = DB::table('tbl')::max('date');
$max = App\TblModel::where('active', 1)->max('date');

As described already, you do not necessarily need an Model for this using the DB::table syntax.

What you should also may want to consider is the performance aspect of your provided answers here (in case you do not use an index on that column at least)

edited Feb 14 '18 at 08:06

answered Feb 14 '18 at 05:28

patriziotomato

591
1
11
25

who is downvoting without any comment? – patriziotomato Feb 14 '18 at 05:33
Sure, I added the example just 1 minute afterwards. Immediate downvoting in this manner is worth thinking about! – patriziotomato Feb 14 '18 at 07:56
Background: I added this comment from my mobile first, then it took some seconds to paste the example. Now on my desktop I'm thinking about the friendly guys used the chance to downvote before I wanted to add even more details on my desktop. As I said, that's kind of impolite. – patriziotomato Feb 14 '18 at 08:01

How to retrieve data from the latest date in laravel?

4 Answers4

You can use latest():

Or

You can use `latest()`: