回答編集履歴
1
TYPO: INTERVAL
test
CHANGED
|
@@ -2,6 +2,6 @@
|
|
|
2
2
|
|
|
3
3
|
```SQL
|
|
4
4
|
SELECT
|
|
5
|
-
DATE '19800101' + CASE WHEN SUBSTR('19800101', 5) = '0229' THEN INTERVAL '65 YEARS 1 DAY' ELSE '65 YEARS' END,
|
|
5
|
+
DATE '19800101' + CASE WHEN SUBSTR('19800101', 5) = '0229' THEN INTERVAL '65 YEARS 1 DAY' ELSE INTERVAL '65 YEARS' END,
|
|
6
|
-
DATE '19800229' + CASE WHEN SUBSTR('19800229', 5) = '0229' THEN INTERVAL '65 YEARS 1 DAY' ELSE '65 YEARS' END
|
|
6
|
+
DATE '19800229' + CASE WHEN SUBSTR('19800229', 5) = '0229' THEN INTERVAL '65 YEARS 1 DAY' ELSE INTERVAL '65 YEARS' END
|
|
7
7
|
```
|