Closed shg25 closed 1 year ago
ローカルでクエリを見てみる
確認!
SELECT DATE_TRUNC('month', "airs_nanitozo"."created_at" AT TIME ZONE 'Asia/Tokyo') AS "monthly_date", COUNT("airs_nanitozo"."id") AS "count" FROM "airs_nanitozo" WHERE "airs_nanitozo"."user_id" = 2 GROUP BY DATE_TRUNC('month', "airs_nanitozo"."created_at" AT TIME ZONE 'Asia/Tokyo') ORDER BY "monthly_date" ASC
良し悪しはそんなに分からないけど、違和感はなさそうかな?
クローズ!
172