Hi:
9.6.0 on linux
I have a table which logs the inception of an event with an "incept_datetime" (timestamptz) field. I want to know how many events occurred per day from one date to the next using midnight as a marker for each day reported. The end result should be something like...
2019-06-23 44
2019-06-23 44
2019-06-24 18
2019-06-25 38
etc...
Is there a query that can do this ?