interval

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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**: ​