Grouping values ​​by days if the field is in timestamp format?

Question

PHP

Good evening comrade friends.
There are collections in monge in which fields with the date of addition in the timestamp format:
date_add: 1484249082
how do I group them to get a selection ala:

{
date: 2017-01-01
count:3
},
{
date: 2017-01-02
count:4
},
{
date: 2017-01-03
count:0
},
...

Answer 1

SELECT ... GROUP BY DATE(`datetimecolumn`)
From here took
Not it? Or basically json should be the view?