回答編集履歴
4
訂正
answer
CHANGED
|
@@ -3,8 +3,8 @@
|
|
|
3
3
|
select
|
|
4
4
|
'2020/12/09'::date + (time_range || 'minute')::interval as scale_time_from
|
|
5
5
|
, '2020/12/09'::date + (time_range + 10 || 'minute')::interval as scale_time_to
|
|
6
|
-
from GENERATE_SERIES(0,
|
|
6
|
+
from GENERATE_SERIES(0, 1439, 10) as time_range(time_range)
|
|
7
|
-
-- 0始まりで10毎に
|
|
7
|
+
-- 0始まりで10毎に1439までで一日分を生成
|
|
8
8
|
```
|
|
9
9
|
後は上記目盛を軸にデータを結合して集計。
|
|
10
10
|
```SQL
|
|
@@ -13,7 +13,7 @@
|
|
|
13
13
|
select
|
|
14
14
|
'2020/12/09'::date + (time_range || 'minute')::interval as time_from
|
|
15
15
|
, '2020/12/09'::date + (time_range + 10 || 'minute')::interval as time_to
|
|
16
|
-
from GENERATE_SERIES(0,
|
|
16
|
+
from GENERATE_SERIES(0, 1439, 10) as time_range(time_range)
|
|
17
17
|
) scale
|
|
18
18
|
left join test
|
|
19
19
|
on test.日時 >= scale.time_from and test.日時 < scale.time_to
|
3
訂正
answer
CHANGED
|
@@ -13,7 +13,7 @@
|
|
|
13
13
|
select
|
|
14
14
|
'2020/12/09'::date + (time_range || 'minute')::interval as time_from
|
|
15
15
|
, '2020/12/09'::date + (time_range + 10 || 'minute')::interval as time_to
|
|
16
|
-
from GENERATE_SERIES(0,
|
|
16
|
+
from GENERATE_SERIES(0, 1440, 10) as time_range(time_range)
|
|
17
17
|
) scale
|
|
18
18
|
left join test
|
|
19
19
|
on test.日時 >= scale.time_from and test.日時 < scale.time_to
|
2
訂正
answer
CHANGED
|
@@ -3,8 +3,8 @@
|
|
|
3
3
|
select
|
|
4
4
|
'2020/12/09'::date + (time_range || 'minute')::interval as scale_time_from
|
|
5
5
|
, '2020/12/09'::date + (time_range + 10 || 'minute')::interval as scale_time_to
|
|
6
|
-
from GENERATE_SERIES(0,
|
|
6
|
+
from GENERATE_SERIES(0, 1440, 10) as time_range(time_range)
|
|
7
|
-
-- 0始まりで10毎に
|
|
7
|
+
-- 0始まりで10毎に1440までで一日分を生成
|
|
8
8
|
```
|
|
9
9
|
後は上記目盛を軸にデータを結合して集計。
|
|
10
10
|
```SQL
|
1
推敲
answer
CHANGED
|
@@ -3,7 +3,8 @@
|
|
|
3
3
|
select
|
|
4
4
|
'2020/12/09'::date + (time_range || 'minute')::interval as scale_time_from
|
|
5
5
|
, '2020/12/09'::date + (time_range + 10 || 'minute')::interval as scale_time_to
|
|
6
|
-
from GENERATE_SERIES(0, 3600, 10) as time_range(time_range)
|
|
6
|
+
from GENERATE_SERIES(0, 3600, 10) as time_range(time_range)
|
|
7
|
+
-- 0始まりで10毎に3600までで一日分を生成
|
|
7
8
|
```
|
|
8
9
|
後は上記目盛を軸にデータを結合して集計。
|
|
9
10
|
```SQL
|