DAY/de - Revision history

Peter: Created page with "Category:Deutsch
Kompatibilität
DAY(d)

'''DBMS''' <caption>Kompatibilität</caption>
<tr><th colspan='3'>DAY(d)</th></tr>
<tr><td align='center'>'''DBMS'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr>
<tr><td align='left'>Ingres</td><td>Nein</td><td>[[EXTRACT/de | EXTRACT(DAY from d)]]</td></tr>
<tr><td align='left'>MySQL</td><td>Ja</td><td>[[EXTRACT/de | EXTRACT(DAY from d)]]</td></tr>
<tr><td align='left'>Oracle</td><td>Nein</td><td>[[TO_CHAR(dates)/de | TO_CHAR(d,'DD')]]</td></tr>
<tr><td align='left'>PostgreSQL</td><td>Nein</td><td>[[EXTRACT/de | EXTRACT(DAY from d)]]</td></tr>
<tr><td align='left'>SQL Server</td><td>Ja</td><td>[[DATEPART/de | DATEPART(DAY,d)]]</td></tr>
</table>

<h1>DAY</h1>
<p>Mit DAY wird der Tag aus einem Datumswert ermittelt.</p>
<p></p>
<pre style='width:60ex'>
DAY(d)
</pre>

<div class='ht'>
In diesem Beispiel wird der Tag aus dem <code>whn</code>-Datum ermittelt.
<source lang='sql' class='def e-ingres'>
SELECT EXTRACT(DAY from whn) AS v
,whn
,wht
FROM eclipse
</source>
<source lang='sql' class='def e-postgres'>
SELECT EXTRACT(DAY from whn) AS v
,whn
,wht
FROM eclipse
</source>
<source lang='sql' class='def e-oracle'>
SELECT TO_CHAR(whn,'DAY') AS v
,whn
,wht
FROM gisq.eclipse
</source>
<source lang='sql' class='def'>
SELECT DAY(whn) AS v
,whn
,wht
FROM eclipse
</source>
</div>

<p>Siehe auch</p>
<ul>
<li>[[EXTRACT/de | EXTRACT function]]</li>
<li>[[%2B(dates)/de | +(date) function]]</li>
<li>[[MONTH/de | MONTH function]]</li>
<li>[[HOUR/de | HOUR function]]</li>
<li>[[MINUTE/de | MINUTE function]]</li>
<li>[[SECOND/de | SECOND function]]</li>
</ul>

{{Languages}}