回答編集履歴
2
SQL修正
test
CHANGED
@@ -30,21 +30,25 @@
|
|
30
30
|
|
31
31
|
CASE TO_CHAR(SYSDATE, 'D')
|
32
32
|
|
33
|
-
WHEN '1' THEN '日曜'
|
33
|
+
WHEN '1' THEN '日曜'
|
34
34
|
|
35
|
-
WHEN '2' THEN '月曜'
|
35
|
+
WHEN '2' THEN '月曜'
|
36
36
|
|
37
|
-
WHEN '3' THEN '火曜'
|
37
|
+
WHEN '3' THEN '火曜'
|
38
38
|
|
39
|
-
WHEN '4' THEN '水曜'
|
39
|
+
WHEN '4' THEN '水曜'
|
40
40
|
|
41
|
-
WHEN '5' THEN '木曜'
|
41
|
+
WHEN '5' THEN '木曜'
|
42
42
|
|
43
|
-
WHEN '6' THEN '金曜'
|
43
|
+
WHEN '6' THEN '金曜'
|
44
44
|
|
45
|
-
WHEN '7' THEN '土曜'
|
45
|
+
WHEN '7' THEN '土曜'
|
46
46
|
|
47
|
+
END
|
48
|
+
|
49
|
+
)
|
50
|
+
|
47
|
-
|
51
|
+
AS 曜日 FROM DUAL
|
48
52
|
|
49
53
|
⇒金曜
|
50
54
|
|
1
SQL修正
test
CHANGED
@@ -26,25 +26,25 @@
|
|
26
26
|
|
27
27
|
SELECT
|
28
28
|
|
29
|
-
|
29
|
+
(
|
30
30
|
|
31
|
-
|
31
|
+
CASE TO_CHAR(SYSDATE, 'D')
|
32
32
|
|
33
|
-
WHEN '
|
33
|
+
WHEN '1' THEN '日曜'
|
34
34
|
|
35
|
-
WHEN '
|
35
|
+
WHEN '2' THEN '月曜'
|
36
36
|
|
37
|
-
WHEN '
|
37
|
+
WHEN '3' THEN '火曜'
|
38
38
|
|
39
|
-
WHEN '
|
39
|
+
WHEN '4' THEN '水曜'
|
40
40
|
|
41
|
-
WHEN '
|
41
|
+
WHEN '5' THEN '木曜'
|
42
42
|
|
43
|
-
WHEN '
|
43
|
+
WHEN '6' THEN '金曜'
|
44
44
|
|
45
|
-
E
|
45
|
+
WHEN '7' THEN '土曜' END
|
46
46
|
|
47
|
-
FROM DUAL
|
47
|
+
) AS 曜日 FROM DUAL
|
48
48
|
|
49
49
|
⇒金曜
|
50
50
|
|