http://sqlzoo.net/w/index.php?title=DATEPART/de&feed=atom&action=history
DATEPART/de - Revision history
2013-05-21T17:02:39Z
Revision history for this page on the wiki
MediaWiki 1.20.4
http://sqlzoo.net/w/index.php?title=DATEPART/de&diff=4225&oldid=prev
Peter: Created page with "Category:Deutsch <table align='right' border='1'> <caption>Kompatibilität</caption> <tr><th colspan='3'>DATEPART(YEAR, d)</th></tr> <tr><td align='center'>'''DBMS'''</td>..."
2012-10-21T17:57:58Z
<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'>DATEPART(YEAR, d)</th></tr> <tr><td align='center'>'''DBMS'''</td>..."</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'>DATEPART(YEAR, 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(YEAR FROM d)]]</td></tr><br />
<tr><td align='left'>MySQL</td><td>Nein</td><td>[[EXTRACT/de | EXTRACT(YEAR FROM d)]]</td></tr><br />
<tr><td align='left'>Oracle</td><td>Nein</td><td>[[EXTRACT/de | EXTRACT(YEAR FROM d)]]</td></tr><br />
<tr><td align='left'>PostgreSQL</td><td>Nein</td><td>[[EXTRACT/de | EXTRACT(YEAR FROM d)]]</td></tr><br />
<tr><td align='left'>SQL Server</td><td>Ja</td><td>DATEPART(YEAR, d)</td></tr><br />
</table><br />
<br />
<h1>DATEPART</h1><br />
<p>Mit DATEPART werden Teile eines Datumswertes ermittelt.</p><br />
<p>Es können Jahr (YEAR), Monat (MONTH), Tag (DAY), Stunde (HOUR), Minute (MINUTE) und Sekunde (SECOND) als Teil ermittelt werden.</p> <br />
<pre style='width:70ex'><br />
DATEPART(YEAR, d) DATEPART(MONTH, d)<br />
DATEPART(DAY, d) DATEPART(HOUR, d)<br />
DATEPART(MINUTE, d) DATEPART(SECOND, d) <br />
</pre><br />
<br />
<div class='ht'><br />
<div class=params>schema:gisq</div><br />
In diesem Beispiel werden Jahr (YEAR) und Monat (MONTH) aus dem <code>whn</code>-Datum ermittelt.<br />
<source lang='sql' class='def e-sqlserver'><br />
SELECT whn<br />
,DATEPART(YEAR, whn) AS yr<br />
,DATEPART(MONTH, whn) AS mnth<br />
FROM eclipse<br />
</source> <br />
<source lang ='sql' class='def e-oracle'>SELECT whn<br />
,EXTRACT(YEAR FROM td) AS yr<br />
,EXTRACT(MONTH FROM td) AS mnth<br />
FROM gisq.eclipse <br />
</source><br />
<source lang ='sql' class='def'>SELECT whn<br />
,EXTRACT(YEAR FROM td) AS yr<br />
,EXTRACT(MONTH FROM td) AS mnth<br />
FROM eclipse <br />
</source><br />
</div><br />
<br />
<p>Siehe auch</p><br />
<ul><br />
<li>[[%2B(dates)/de |+ date]]</li><br />
</ul><br />
<br />
{{Languages}}</div>
Peter