http://sqlzoo.net/w/index.php?title=%2B_INTERVAL&feed=atom&action=history
+ INTERVAL - Revision history
2013-05-25T18:00:09Z
Revision history for this page on the wiki
MediaWiki 1.20.4
http://sqlzoo.net/w/index.php?title=%2B_INTERVAL&diff=4007&oldid=prev
Peter at 09:09, 6 September 2012
2012-09-06T09:09:19Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 09:09, 6 September 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 42:</td>
<td colspan="2" class="diff-lineno">Line 42:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"><p>See also</p></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[EXTRACT |EXTRACT function]]</li></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[EXTRACT |EXTRACT function]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">{{Languages}}</ins></div></td></tr>
</table>
Peter
http://sqlzoo.net/w/index.php?title=%2B_INTERVAL&diff=1387&oldid=prev
Connor at 15:17, 16 July 2012
2012-07-16T15:17:10Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 15:17, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 25:</td>
<td colspan="2" class="diff-lineno">Line 25:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class='ht'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class='ht'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>In this example we show the date 7 days after the value specified in <code>whn</code>  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>In this example we show the date 7 days after the value specified in <code>whn</code>  </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle'>SELECT whn, <del class="diffchange diffchange-inline">DATE</del>(whn) + 7  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle'>SELECT whn, (whn) + 7  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM gisq.eclipse</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM gisq.eclipse</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlserver'>SELECT whn, <del class="diffchange diffchange-inline">DATE</del>(whn) + 7  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlserver'>SELECT whn, (whn) + 7  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM eclipse</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM eclipse</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=%2B_INTERVAL&diff=1386&oldid=prev
Connor at 15:16, 16 July 2012
2012-07-16T15:16:13Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 15:16, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 26:</td>
<td colspan="2" class="diff-lineno">Line 26:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>In this example we show the date 7 days after the value specified in <code>whn</code>  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>In this example we show the date 7 days after the value specified in <code>whn</code>  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle'>SELECT whn, DATE(whn) + 7  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle'>SELECT whn, DATE(whn) + 7  </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   FROM eclipse</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   FROM <ins class="diffchange diffchange-inline">gisq.</ins>eclipse</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlserver'>SELECT whn, DATE(whn) + 7  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-sqlserver'>SELECT whn, DATE(whn) + 7  </div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=%2B_INTERVAL&diff=1385&oldid=prev
Connor at 15:15, 16 July 2012
2012-07-16T15:15:28Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 15:15, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 4:</td>
<td colspan="2" class="diff-lineno">Line 4:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><th colspan='3'>d+ INTERVAL i DAY</th></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><th colspan='3'>d+ INTERVAL i DAY</th></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>mysql</td><td>Yes</td><td>[[d+ i]]</td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>mysql</td><td>Yes</td><td>[[<ins class="diffchange diffchange-inline">%2B(dates) |</ins>d+ i]]</td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>oracle</td><td>No</td><td>[[d+ i]]</td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>oracle</td><td>No</td><td>[[<ins class="diffchange diffchange-inline">%2B(dates) |</ins>d+ i]]</td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>postgres</td><td>No</td><td>[[d+ i]]</td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>postgres</td><td>No</td><td>[[<ins class="diffchange diffchange-inline">%2B(dates) |</ins>d+ i]]</td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>No</td><td>[[d+ i]]</td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>No</td><td>[[<ins class="diffchange diffchange-inline">%2B(dates) |</ins>d+ i]]</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p><code><i>d</i> + INTERVAL <i>i</i> DAY</code></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p><code><i>d</i> + INTERVAL <i>i</i> DAY</code></div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=%2B_INTERVAL&diff=1188&oldid=prev
Connor at 11:36, 13 July 2012
2012-07-13T11:36:37Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 11:36, 13 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 43:</td>
<td colspan="2" class="diff-lineno">Line 43:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   <li>[[EXTRACT function]]</li></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   <li>[[<ins class="diffchange diffchange-inline">EXTRACT |</ins>EXTRACT function]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=%2B_INTERVAL&diff=1164&oldid=prev
Connor at 10:50, 13 July 2012
2012-07-13T10:50:51Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 10:50, 13 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><<del class="diffchange diffchange-inline">h3</del>>+ INTERVAL</<del class="diffchange diffchange-inline">h3</del>></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><<ins class="diffchange diffchange-inline">h1</ins>>+ INTERVAL</<ins class="diffchange diffchange-inline">h1</ins>></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><table align='right' border='1'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><table align='right' border='1'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><caption>Compatibility</caption></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><caption>Compatibility</caption></div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=%2B_INTERVAL&diff=1158&oldid=prev
Connor at 10:29, 13 July 2012
2012-07-13T10:29:58Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 10:29, 13 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 23:</td>
<td colspan="2" class="diff-lineno">Line 23:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class=params>schema:gisq</div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class=params>schema:gisq</div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><div class='<del class="diffchange diffchange-inline">qu</del>'></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><div class='<ins class="diffchange diffchange-inline">ht</ins>'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>In this example we show the date 7 days after the value specified in <code>whn</code>  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>In this example we show the date 7 days after the value specified in <code>whn</code>  </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><source lang='sql' class='def'></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><source lang='sql' class='def <ins class="diffchange diffchange-inline">e-oracle</ins>'>SELECT whn, <ins class="diffchange diffchange-inline">DATE(</ins>whn<ins class="diffchange diffchange-inline">) </ins>+ 7  </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>SELECT whn, whn+<del class="diffchange diffchange-inline">INTERVAL </del>7 <del class="diffchange diffchange-inline">DAY</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM eclipse</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM eclipse</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div> </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline"><source lang='sql' class='def e-sqlserver'>SELECT whn, DATE(whn) + 7 </ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><source lang='sql' class='<del class="diffchange diffchange-inline">ans</del>'></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">  FROM eclipse</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline"></source></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline"><source lang='sql' class='def e-ingres'>SELECT whn, whn + DATE(7 day)</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">  FROM eclipse</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline"></source></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline"><source lang='sql' class='def e-postgres'>SELECT whn, whn + 7 </ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">  FROM eclipse</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline"></source></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><source lang='sql' class='<ins class="diffchange diffchange-inline">def</ins>'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT whn, whn+INTERVAL 7 DAY</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT whn, whn+INTERVAL 7 DAY</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM eclipse</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM eclipse</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;"></del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[EXTRACT function]]</li></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[EXTRACT function]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=%2B_INTERVAL&diff=1129&oldid=prev
Connor at 08:38, 13 July 2012
2012-07-13T08:38:58Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 08:38, 13 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 3:</td>
<td colspan="2" class="diff-lineno">Line 3:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><caption>Compatibility</caption></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><caption>Compatibility</caption></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><th colspan='3'>d+ INTERVAL i DAY</th></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><th colspan='3'>d+ INTERVAL i DAY</th></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='center'>Engine</td><td align='center'>OK</td><td align='center'>Alternative</td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='center'><ins class="diffchange diffchange-inline">'''</ins>Engine<ins class="diffchange diffchange-inline">'''</ins></td><td align='center'><ins class="diffchange diffchange-inline">'''</ins>OK<ins class="diffchange diffchange-inline">'''</ins></td><td align='center'><ins class="diffchange diffchange-inline">'''</ins>Alternative<ins class="diffchange diffchange-inline">'''</ins></td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>mysql</td><td>Yes</td><td>[[d+ i]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>mysql</td><td>Yes</td><td>[[d+ i]]</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>oracle</td><td>No</td><td>[[d+ i]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>oracle</td><td>No</td><td>[[d+ i]]</td></tr></div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=%2B_INTERVAL&diff=1128&oldid=prev
Connor at 08:36, 13 July 2012
2012-07-13T08:36:36Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 08:36, 13 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 2:</td>
<td colspan="2" class="diff-lineno">Line 2:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><table align='right' border='1'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><table align='right' border='1'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><caption>Compatibility</caption></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><caption>Compatibility</caption></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><<del class="diffchange diffchange-inline">caption</del>><del class="diffchange diffchange-inline">ABS(f)</del></<del class="diffchange diffchange-inline">caption</del>></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><<ins class="diffchange diffchange-inline">tr</ins>><ins class="diffchange diffchange-inline"><th colspan='3'>d+ INTERVAL i DAY</ins></<ins class="diffchange diffchange-inline">th></tr</ins>></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><<del class="diffchange diffchange-inline">th</del>>Engine</<del class="diffchange diffchange-inline">th</del>><<del class="diffchange diffchange-inline">th</del>>OK</<del class="diffchange diffchange-inline">th</del>><<del class="diffchange diffchange-inline">th</del>>Alternative</<del class="diffchange diffchange-inline">th</del>></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><<ins class="diffchange diffchange-inline">td align='center'</ins>>Engine</<ins class="diffchange diffchange-inline">td</ins>><<ins class="diffchange diffchange-inline">td align='center'</ins>>OK</<ins class="diffchange diffchange-inline">td</ins>><<ins class="diffchange diffchange-inline">td align='center'</ins>>Alternative</<ins class="diffchange diffchange-inline">td</ins>></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>mysql</td><td>Yes</td><td>[[d+ i]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>mysql</td><td>Yes</td><td>[[d+ i]]</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>oracle</td><td>No</td><td>[[d+ i]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>oracle</td><td>No</td><td>[[d+ i]]</td></tr></div></td></tr>
<tr><td colspan="2" class="diff-lineno">Line 21:</td>
<td colspan="2" class="diff-lineno">Line 21:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  DATE '2006-05-20' + INTERVAL 5 YEAR  -> DATE '2011-05-20'  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>  DATE '2006-05-20' + INTERVAL 5 YEAR  -> DATE '2011-05-20'  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></pre></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></pre></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"><div class=params>schema:gisq</div></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class='qu'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class='qu'></div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=%2B_INTERVAL&diff=1125&oldid=prev
Connor: Created page with "<h3>+ INTERVAL</h3> <table align='right' border='1'> <caption>Compatibility</caption> <caption>ABS(f)</caption> <tr><th>Engine</th><th>OK</th><th>Alternative</th></tr> <tr><td..."
2012-07-12T16:00:46Z
<p>Created page with "<h3>+ INTERVAL</h3> <table align='right' border='1'> <caption>Compatibility</caption> <caption>ABS(f)</caption> <tr><th>Engine</th><th>OK</th><th>Alternative</th></tr> <tr><td..."</p>
<p><b>New page</b></p><div><h3>+ INTERVAL</h3><br />
<table align='right' border='1'><br />
<caption>Compatibility</caption><br />
<caption>ABS(f)</caption><br />
<tr><th>Engine</th><th>OK</th><th>Alternative</th></tr><br />
<tr><td align='left'>mysql</td><td>Yes</td><td>[[d+ i]]</td></tr><br />
<tr><td align='left'>oracle</td><td>No</td><td>[[d+ i]]</td></tr><br />
<tr><td align='left'>postgres</td><td>No</td><td>[[d+ i]]</td></tr><br />
<tr><td align='left'>sqlserver</td><td>No</td><td>[[d+ i]]</td></tr><br />
</table><br />
<p><code><i>d</i> + INTERVAL <i>i</i> DAY</code><br />
returns the date <i>i</i> days after the date <i>d</i>.<br />
</p><br />
<p>You can also add YEAR, MONTH, DAY, HOUR, MINUTE, SECOND<br />
</p><br />
<p>You can also add a negative value.<br />
</p><br />
<pre style='width:80ex'><br />
DATE '2006-05-20' + INTERVAL 5 DAY -> DATE '2006-05-25' <br />
DATE '2006-05-20' + INTERVAL 5 MONTH -> DATE '2006-10-20' <br />
DATE '2006-05-20' + INTERVAL 5 YEAR -> DATE '2011-05-20' <br />
</pre><br />
<br />
<div class='qu'><br />
In this example we show the date 7 days after the value specified in <code>whn</code> <br />
<source lang='sql' class='def'><br />
SELECT whn, whn+INTERVAL 7 DAY<br />
FROM eclipse<br />
</source><br />
<br />
<source lang='sql' class='ans'><br />
SELECT whn, whn+INTERVAL 7 DAY<br />
FROM eclipse<br />
</source><br />
</div><br />
<br />
<ul><br />
<li>[[EXTRACT function]]</li><br />
</ul></div>
Connor