This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
interval [2016/01/27 08:58] dmtolpeko |
interval [2016/01/27 10:18] dmtolpeko |
||
---|---|---|---|
Line 40: | Line 40: | ||
2015-03-15 00:00:00 | 2015-03-15 00:00:00 | ||
</code> | </code> | ||
- | **Compatibility:** IBM DB2 | ||
**Example 3**: | **Example 3**: | ||
Line 67: | Line 66: | ||
<code language=sql> | <code language=sql> | ||
- | date '2015-03-12' - interval '3' day; | + | date '2016-01-27' - interval '3' day; |
-- | -- | ||
- | 2015-03-11 | + | 2016-01-24 |
</code> | </code> | ||
+ | |||
+ | **Compatibility:** IBM DB2, Oracle, Teradata | ||
**Version**: | **Version**: |