http://sqlzoo.net/w/index.php?title=%2B(dates)/de&feed=atom&action=history 2013-06-19T01:10:10Z Revision history for this page on the wiki MediaWiki 1.20.4 http://sqlzoo.net/w/index.php?title=%2B(dates)/de&diff=4208&oldid=prev 2012-10-21T17:18:46Z

<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 17:18, 21 October 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 7:</td> <td colspan="2" class="diff-lineno">Line 7:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;MySQL&lt;/td&gt;&lt;td&gt;Ja&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;MySQL&lt;/td&gt;&lt;td&gt;Ja&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;Oracle&lt;/td&gt;&lt;td&gt;Ja&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;Oracle&lt;/td&gt;&lt;td&gt;Ja&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;PostgreSQL&lt;/td&gt;&lt;td&gt;Nein&lt;/td&gt;&lt;td&gt;[[%2B_INTERVAL |d+ INTERVAL 'i DAY']]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;PostgreSQL&lt;/td&gt;&lt;td&gt;Nein&lt;/td&gt;&lt;td&gt;[[%2B_INTERVAL<ins class="diffchange diffchange-inline">/de </ins>|d+ INTERVAL 'i DAY']]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;SQL Server&lt;/td&gt;&lt;td&gt;Ja&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;SQL Server&lt;/td&gt;&lt;td&gt;Ja&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno">Line 39:</td> <td colspan="2" class="diff-lineno">Line 39:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;Siehe auch&lt;/p&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;Siehe auch&lt;/p&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;ul&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;ul&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[EXTRACT | Funktion EXTRACT]]&lt;/li&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[EXTRACT<ins class="diffchange diffchange-inline">/de </ins>| Funktion EXTRACT]]&lt;/li&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[%2B_INTERVAL |Funktion + INTERVAL]]&lt;/li&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[%2B_INTERVAL<ins class="diffchange diffchange-inline">/de </ins>|Funktion + INTERVAL]]&lt;/li&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/ul&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/ul&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>{{Languages}}</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>{{Languages}}</div></td></tr> </table>

Peter http://sqlzoo.net/w/index.php?title=%2B(dates)/de&diff=4004&oldid=prev 2012-09-06T08:51: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 08:51, 6 September 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 36:</td> <td colspan="2" class="diff-lineno">Line 36:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/source&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/source&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/div&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/div&gt;</div></td></tr> <tr><td colspan="2">&#160;</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">&#160;</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;">&lt;p&gt;Siehe auch&lt;/p&gt;</ins></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;ul&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;ul&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[EXTRACT | Funktion EXTRACT]]&lt;/li&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[EXTRACT | Funktion EXTRACT]]&lt;/li&gt;</div></td></tr> </table>

Peter http://sqlzoo.net/w/index.php?title=%2B(dates)/de&diff=4002&oldid=prev 2012-09-06T08:48:25Z

<p>Created page with &quot;<a href="/wiki/Category:Deutsch" title="Category:Deutsch">Category:Deutsch</a> &lt;table align=&#039;right&#039; border=&#039;1&#039;&gt; &lt;caption&gt;Kompatibilität&lt;/caption&gt; &lt;tr&gt;&lt;th colspan=&#039;3&#039;&gt;d + i&lt;/th&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td align=&#039;center&#039;&gt;&#039;&#039;&#039;DBMS&#039;&#039;&#039;&lt;/td&gt;&lt;td align=&#039;c...&quot;</p> <p><b>New page</b></p><div>[[Category:Deutsch]]<br /> &lt;table align='right' border='1'&gt;<br /> &lt;caption&gt;Kompatibilität&lt;/caption&gt;<br /> &lt;tr&gt;&lt;th colspan='3'&gt;d + i&lt;/th&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='center'&gt;'''DBMS'''&lt;/td&gt;&lt;td align='center'&gt;'''OK'''&lt;/td&gt;&lt;td align='center'&gt;'''Alternative'''&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;Ingres&lt;/td&gt;&lt;td&gt;Nein&lt;/td&gt;&lt;td&gt;whn + date('7 day')&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;MySQL&lt;/td&gt;&lt;td&gt;Ja&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;Oracle&lt;/td&gt;&lt;td&gt;Ja&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;PostgreSQL&lt;/td&gt;&lt;td&gt;Nein&lt;/td&gt;&lt;td&gt;[[%2B_INTERVAL |d+ INTERVAL 'i DAY']]&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;SQL Server&lt;/td&gt;&lt;td&gt;Ja&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;<br /> &lt;/table&gt;<br /> <br /> &lt;h1&gt;+ (dates)&lt;/h1&gt;<br /> &lt;p&gt;d + i liefert ein Datum, das i Tage nach dem Datum d liegt.&lt;/p&gt;<br /> &lt;pre style='width:80ex'&gt;<br /> DATE '2006-05-20' + 7 -&gt; DATE '2006-05-27' <br /> &lt;/pre&gt;<br /> &lt;div class=params&gt;schema:gisq&lt;/div&gt;<br /> &lt;div class='ht'&gt;<br /> Im Beispiel wird ein Datum 7 Tage nach dem Datumswert in &lt;code&gt;whn&lt;/code&gt; ermittelt.<br /> &lt;source lang='sql' class='def e-ingres'&gt;<br /> SELECT whn, whn + DATE('7 day')<br /> FROM eclipse<br /> &lt;/source&gt;<br /> &lt;source lang='sql' class='def e-postgres'&gt;<br /> SELECT whn, whn+INTERVAL 7 DAY<br /> FROM eclipse<br /> &lt;/source&gt;<br /> &lt;source lang='sql' class='def e-oracle'&gt;<br /> SELECT whn, whn+7 <br /> FROM gisq.eclipse<br /> &lt;/source&gt;<br /> &lt;source lang='sql' class='def'&gt;<br /> SELECT whn, whn+7 <br /> FROM eclipse<br /> &lt;/source&gt;<br /> &lt;/div&gt;<br /> &lt;ul&gt;<br /> &lt;li&gt;[[EXTRACT | Funktion EXTRACT]]&lt;/li&gt;<br /> &lt;li&gt;[[%2B_INTERVAL |Funktion + INTERVAL]]&lt;/li&gt;<br /> &lt;/ul&gt;<br /> <br /> {{Languages}}</div>

Peter