回答編集履歴
2
訂正
test
CHANGED
@@ -12,7 +12,7 @@
|
|
12
12
|
|
13
13
|
---
|
14
14
|
|
15
|
-
AND birth_date BETWEEN TO_DATE('2019-10-01', 'YYYY
|
15
|
+
AND birth_date BETWEEN TO_DATE('2019-10-01', 'YYYY-MM-DD') AND TO_DATE('2019-10-05', 'YYYY-MM-DD') ;
|
16
16
|
|
17
17
|
-- ----------------------------------- -----------------------------------
|
18
18
|
|
1
訂正
test
CHANGED
@@ -12,7 +12,7 @@
|
|
12
12
|
|
13
13
|
---
|
14
14
|
|
15
|
-
AND birth_date BETWEEN TO_DATE('2019-10-0
|
15
|
+
AND birth_date BETWEEN TO_DATE('2019-10-01', 'YYYY/MM/DD') AND TO_DATE('2019-10-05', 'YYYY/MM/DD') ;
|
16
16
|
|
17
17
|
-- ----------------------------------- -----------------------------------
|
18
18
|
|