teratail
回答率
85.48%
質問するログイン新規登録
トップC#に関する質問指定した期間のみのデータを集計したい

編集履歴

回答編集履歴

3

改修

2017/04/21 10:45

投稿

A.Ichi
A.Ichi

スコア4070

test CHANGED
File without changes

2

改修

2017/04/21 10:45

投稿

A.Ichi
A.Ichi

スコア4070

test CHANGED
@@ -46,7 +46,7 @@
46
46
 
47
47
  select count(*) FROM tm_user_e
48
48
 
49
- WHERE create_datetime::date between '2012-12-31' AND date '2012-12-31' +interval '3 day' -interval '1 day';
49
+ WHERE create_datetime::date between '2012-12-31' AND date '2012-12-31' +interval '3 day -1 day';
50
50
 
51
51
 
52
52
 

1

変更

2017/04/21 10:45

投稿

A.Ichi
A.Ichi

スコア4070

test CHANGED
@@ -6,13 +6,13 @@
6
6
 
7
7
  select count(*) FROM tm_user_e
8
8
 
9
- WHERE create_datetime::date between '2012-12-31' AND date '2012-12-31' +interval '1 year' -interval '1 day';
9
+ WHERE create_datetime::date between '2012-12-31' AND date '2012-12-31' +interval '1 year -1 day';
10
10
 
11
11
  --２年間
12
12
 
13
13
  select count(*) FROM tm_user_e
14
14
 
15
- WHERE create_datetime::date between '2012-12-31' AND date '2012-12-31' +interval '2 year' -interval '1 day';
15
+ WHERE create_datetime::date between '2012-12-31' AND date '2012-12-31' +interval '2 year -1 day';
16
16
 
17
17
 
18
18
 
@@ -20,13 +20,13 @@
20
20
 
21
21
  select count(*) FROM tm_user_e
22
22
 
23
- WHERE create_datetime::date between '2012-12-31' AND date '2012-12-31' +interval '1 month' -interval '1 day';
23
+ WHERE create_datetime::date between '2012-12-31' AND date '2012-12-31' +interval '1 month -1 day';
24
24
 
25
25
  --２か月
26
26
 
27
27
  select count(*) FROM tm_user_e
28
28
 
29
- WHERE create_datetime::date between '2012-12-31' AND date '2012-12-31' +interval '2 month' -interval '1 day';
29
+ WHERE create_datetime::date between '2012-12-31' AND date '2012-12-31' +interval '2 month -1 day';
30
30
 
31
31
 
32
32
 
@@ -34,7 +34,7 @@
34
34
 
35
35
  select count(*) FROM tm_user_e
36
36
 
37
- WHERE create_datetime::date between '2012-12-31' AND date '2012-12-31' +interval '2 day' -interval '1 day';
37
+ WHERE create_datetime::date between '2012-12-31' AND date '2012-12-31' +interval '2 day -1 day';
38
38
 
39
39
  select count(*) FROM tm_user_e
40
40
 
@@ -48,4 +48,12 @@
48
48
 
49
49
  WHERE create_datetime::date between '2012-12-31' AND date '2012-12-31' +interval '3 day' -interval '1 day';
50
50
 
51
+
52
+
53
+ --１年９か月間
54
+
55
+ select count(*) FROM tm_user_e
56
+
57
+ WHERE create_datetime::date between '2012-12-31' AND date '2012-12-31' +interval '1 year 9 month -1 day';
58
+
51
59
  ```