Level 50
...->orderByRaw('DATE(created_at) DESC')...
Feb 23, 2019
2
Level 1
I have DateTime field in my DB table but i want to sort records only date wise not datetime wise.
created_at is stored as 2019-02-11 18:28:42 but i want to sort my data according to date only from this field.
Query is as shown below:-
$data_rem = Reminder::all()->where('user_id',Auth::user()->id)->where('is_done','0')->where('is_temp_delete','0')->sortByDesc('created_at')->sortBy('priority');
Level 122
remove that all() from the request and use get() at the end.
You are currently getting all records from the database into a collection and then doing everything else in memory rather than with the database.
Please or to participate in this conversation.