Get The Max Date With Laravel Eloquent


Getting the max date with Eloquent is executed by simply using the max() operator to get the maximum date time stamp in any given data table. The following example assumes the date column we are looking at is named created_at, but replace it with your own if needs be.

PHP

$lastRecordDate = Product::all('created_at')->max('created_at')->toArray();

dd($lastRecordDate);

Whilst this Eloquent query gets the maximum date available in the table, it actually gives us more information in the output, another magic gem in Laravel.

Output

If you want to print the date time, it would be a case of the following line of code

echo $lastRecordDate["formatted"]; // outputs 2020-11-21 15:07:00

Hope this helps!





Copyright 2023 Code Wall. All rights reserved.



Source link