Hello

I have a table defined as:

ID integer
ts timestamp
desc varchar(100)

Is it possible with one query to retrieve the number of entries per
day? I assume you would need to cast the timestamp to an integer(?)
and then do some sort of group by.

Ideally, I need the results in the following format:

timestamp, count of entries that day.


preferably with no row returned for days with no entries.

TIA

David