Level 8
Maybe this
Time::whereRaw("DAY(created_at) = '" . Carbon::yesterday()->format('Y-m-d') . "'")->get()
2 likes
Dec 15, 2016
9
Level 10
How to Query Yesterdays records ?
Hi,
How can I query yesterday's record only?.
This is what I have done so far, but not working.
'''
$countYesterday = Timer::where('created_at','=', Carbon::yesterday())->get();
'''
Plus, How about this week and This month as well.
Thank's :)
Level 47
Laravel has some hidden gems for this.
whereDay(), whereMonth(), whereYear()
http://laraveldaily.com/eloquent-date-filtering-wheredate-and-other-methods/
2 likes
Level 20
Is appearing any error?
This should give all records which have date equal to yesterday
$yesterday = date("Y-m-d", strtotime( '-1 days' ) );
$countYesterday = Timer::whereDate('created_at', $yesterday )->get();
Also take a look at documentation for whereDate, whereMonth, whereYear https://laravel.com/docs/5.3/queries#where-clauses
3 likes
Level 1
@petrit Thanks !!!
Level 10
@petrit Thank's, Worked fine :)
Level 10
@jekinney Thank's, It was a great and informative article :)
2 likes
Level 10
@gabrielbuzzi . Thank's :) great solution
Level 1
$yesterday = Timer::whereDate('created_at', Carbon::now()->addDay(-1))->get();
1 like
Level 1
Here's another clean solution using Carbon:
$yesterday = Timer::whereDate('created_at', Carbon::yesterday())->get();
Please or to participate in this conversation.