回答編集履歴
1
誤字
answer
CHANGED
|
@@ -1,7 +1,7 @@
|
|
|
1
1
|
MySQL であれば
|
|
2
2
|
|
|
3
3
|
```
|
|
4
|
-
SELECT DATE_FORMAT(CONVERT_TZ(created_at, '+00:00','+09:00'), '%Y/%m/%d) AS"日付", COUNT(*) AS "データ数"
|
|
4
|
+
SELECT DATE_FORMAT(CONVERT_TZ(created_at, '+00:00', '+09:00'), '%Y/%m/%d) AS"日付", COUNT(*) AS "データ数"
|
|
5
5
|
```
|
|
6
6
|
|
|
7
7
|
でしょうか
|