How to group query result by date (timestamp) in yii2?

Question

Yii

Article table example:
id
title
text
sort_date Query
example:

Article::find()->orderBy('sort_date DESC')->limit(10)->All(),

sort_date - timestamp
As a result, you need to get something like:
10/21/2015
Heading 1
Heading 2
10/20/2015
Heading 3
Heading 4
Heading 5
Heading 6

Answer 1

$articles=Article::find()->orderBy('sort_date DESC')->limit(10)->All();
$sorted_articles=[];
foreach($articles as $article){
      $dt=date('d.m.Y',$article->sort_date);
      $sorted_articles[$dt][]=$article;
}

Answer 2

Try something like

->select('article.*, DATE_FORMAT(FROM_UNIXTIME(`article.sort_date`), \'%d.%m.%Y\') as date')
->orderBy('sort_date')

Well, the public property date can be added to the model so that there is a place to save the value itself.
And you can scatter into an array for specific dates already at the PHP level.

Answer 3

grouped dy sort_date