Re: getting daily stats for event counts

2020-06-23 Thread Tom Lane
David Gauthier 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...

getting daily stats for event counts

2020-06-23 Thread David Gauthier
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