Level 5
@ardf16 Try
Post::select(DB::raw("DATE_FORMAT(updated_at, \"%m-%Y\") AS updated_month"))
->groupBy('updated_month')
>orderBy('updated_month', 'DESC')
>get();
Mar 2, 2018
4
Level 5
Very wierd sorting issue
Hi, i have this query:
Post::select(DB::raw("DATE_FORMAT(updated_at, \"%m-%Y\") AS updated_month"))
->groupBy('updated_month')
>orderBy(DB::raw("STR_TO_DATE(updated_month, \"%m-%Y\")"), 'DESC')
>get();
wchich outputs query:
select DATE_FORMAT(updated_at, "%m-%Y") AS updated_month from `posts` group by `updated_month` order by STR_TO_DATE(updated_month, "%m-%Y") desc
Eloquent returns collection unsorted... The same exact query in heidisql returns dates properly sorted.
what's going on here?
Level 67
It would also probably be better to sort by Y-m rather than m-Y if you're trying to get an actual chronological order
Level 2
You can use month and year and why not 1 string in raw??
year(now()), month(now())
Level 5
Ok i think friday afternoon fever got me. What about:
DB::raw("DATE_FORMAT(updated_at, \"%m-%Y\") AS updated_month"))
->groupBy('updated_month')
->orderBy('updated_at', 'DESC')
->get();
Please or to participate in this conversation.