How to make a query with the formation of the date of mySQL?

Question

there is such a request

SELECT name_film, date( from_unixtime( created_at ) ) created_at FROM `fl_films` ORDER BY created_at

Is it possible to make it in ActiveRecord?

NPreston NPreston 411 3 silver marks 10 bronze marks · Accepted Answer · 2016-05-12T11:45:20

Create a class, for example:

 class Films extends \yii\db\ActiveRecord { public static function tableName() { return 'fl_films'; } }

And then generate a query to the database, for example:

 $customers = Films::find() ->select(['name_film', 'date(from_unixtime(created_at)) created_at']) ->orderBy('created_at') ->all();

Sergalas Sergalas 1,737 11 silver marks 35 bronze marks · Answer 2 · 2016-05-14T16:05:24

 date(from_unixtime(created_at))

unfortunately only gives 2016 more correct:

 Films::find() ->select(['name_film', 'date_format(from_unixtime(created_at),"%d%m%Y") created_at']) ->orderBy('created_at') ->all();

2 answers 2