David Gauthier <davegauthierpg@gmail.com> writes:
> 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-24 18
> 2019-06-25 38
> etc...
> Is there a query that can do this ?
Something involving GROUP BY date_trunc('day', incept_datetime)
ought to do it, possibly with some fooling around required
depending on what definition of "midnight" you want to use.
regards, tom lane