|
SELECT TIMESTAMP'2001-01-01 10:20:30' - INTERVAL '10' YEAR AS c1,
|
-INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c2;
|
+---------------------+-----------------+
|
| c1 | c2 |
|
+---------------------+-----------------+
|
| 1991-01-01 10:20:30 | -20110101102030 |
|
+---------------------+-----------------+
|
The result for c2 is wrong. It should be the same with c1.
PostgreSQL returns correct results for the same query:
c1 | c2
|
---------------------+---------------------
|
1991-01-01 10:20:30 | 1991-01-01 10:20:30
|
|