http://sqlzoo.net/w/index.php?title=HOUR/de&feed=atom&action=history
HOUR/de - Revision history
2013-05-20T16:40:23Z
Revision history for this page on the wiki
MediaWiki 1.20.4
http://sqlzoo.net/w/index.php?title=HOUR/de&diff=4239&oldid=prev
Peter at 21:17, 21 October 2012
2012-10-21T21:17:24Z
<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 21:17, 21 October 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 19:</td>
<td colspan="2" class="diff-lineno">Line 19:</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='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: #ffa; color:black; font-size: smaller;"><div>In diesem Beispiel wird die Stunde aus dem <code>whn</code>-<del class="diffchange diffchange-inline">Datums-/Zeitwert </del>ermittelt.   </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>In diesem Beispiel wird die Stunde aus dem <code>whn</code>-<ins class="diffchange diffchange-inline">Datumswert </ins>ermittelt.   </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-ingres'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-ingres'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT EXTRACT(HOUR from whn) AS v</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT EXTRACT(HOUR from whn) AS v</div></td></tr>
</table>
Peter
http://sqlzoo.net/w/index.php?title=HOUR/de&diff=4236&oldid=prev
Peter: Created page with "Category:Deutsch <table align='right' border='1'> <caption>Kompatibilität</caption> <tr><th colspan='3'>HOUR(d)</th></tr> <tr><td align='center'>'''DBMS'''</td><td align=..."
2012-10-21T21:11:17Z
<p>Created page with "<a href="/wiki/Category:Deutsch" title="Category:Deutsch">Category:Deutsch</a> <table align='right' border='1'> <caption>Kompatibilität</caption> <tr><th colspan='3'>HOUR(d)</th></tr> <tr><td align='center'>'''DBMS'''</td><td align=..."</p>
<p><b>New page</b></p><div>[[Category:Deutsch]]<br />
<table align='right' border='1'><br />
<caption>Kompatibilität</caption><br />
<tr><th colspan='3'>HOUR(d)</th></tr><br />
<tr><td align='center'>'''DBMS'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr><br />
<tr><td align='left'>Ingres</td><td>Nein</td><td>[[EXTRACT/de | EXTRACT(HOUR from d)]]</td></tr><br />
<tr><td align='left'>MySQL</td><td>Ja</td><td>[[EXTRACT/de | EXTRACT(HOUR from d)]]</td></tr><br />
<tr><td align='left'>Oracle</td><td>Nein</td><td>[[TO_CHAR(dates)/de | TO_CHAR(d,'HH24')]]</td></tr><br />
<tr><td align='left'>PostgreSQL</td><td>Nein</td><td>[[EXTRACT/de | EXTRACT(HOUR from d)]]</td></tr><br />
<tr><td align='left'>SQL Server</td><td>Ja</td><td>[[DATEPART/de | DATEPART(HOUR,d)]]</td></tr><br />
</table><br />
<br />
<h1>HOUR</h1><br />
<p>HOUR ermittelt die Stunde aus einem Datums-/Zeitwert.</p><br />
<p></p> <br />
<pre style='width:60ex'><br />
HOUR(d)<br />
</pre><br />
<br />
<div class='ht'><br />
In diesem Beispiel wird die Stunde aus dem <code>whn</code>-Datums-/Zeitwert ermittelt. <br />
<source lang='sql' class='def e-ingres'><br />
SELECT EXTRACT(HOUR from whn) AS v<br />
,whn<br />
,wht<br />
FROM eclipse<br />
</source><br />
<source lang='sql' class='def e-postgres'><br />
SELECT EXTRACT(HOUR from whn) AS v<br />
,whn<br />
,wht<br />
FROM eclipse<br />
</source><br />
<source lang='sql' class='def e-oracle'><br />
SELECT TO_CHAR(whn,'HOUR') AS v<br />
,whn<br />
,wht<br />
FROM gisq.eclipse<br />
</source><br />
<source lang='sql' class='def'><br />
SELECT HOUR(whn) AS v, whn, wht<br />
FROM eclipse<br />
</source><br />
</div><br />
<br />
<p>Siehe auch</p><br />
<ul><br />
<li>[[EXTRACT/de | Funktion EXTRACT]]</li><br />
<li>[[%2B(dates)/de | Funktion +(date)]]</li><br />
<li>[[MONTH/de | Funktion MONTH]]</li><br />
<li>[[MINUTE/de | Funktion MINUTE]]</li><br />
<li>[[DAY/de | Funktion DAY]]</li><br />
<li>[[SECOND/de | Funktion SECOND]]</li><br />
</ul><br />
<br />
{{Languages}}</div>
Peter