Skip to content
Advertisement

Tag: cockroachdb

Group by days of a month in CockroachDB

In CockroachDB, I want to have such this query on a specific month for its every day: the problem is that I want it on my local date. What should I do? My goal is: “month, day, count, sum” as result columns for a month. UPDATE: I have found a suitable query for this purpose: Thanks to @histocrat for easier

Advertisement