Difference between revisions of "+(dates)/de"

From SQLZOO
Jump to: navigation, search
(Created page with "Category:Deutsch <table align='right' border='1'> <caption>Kompatibilität</caption> <tr><th colspan='3'>d + i</th></tr> <tr><td align='center'>'''DBMS'''</td><td align='c...")
 
 
(One intermediate revision by one user not shown)
Line 7: Line 7:
 
<tr><td align='left'>MySQL</td><td>Ja</td><td></td></tr>
 
<tr><td align='left'>MySQL</td><td>Ja</td><td></td></tr>
 
<tr><td align='left'>Oracle</td><td>Ja</td><td></td></tr>
 
<tr><td align='left'>Oracle</td><td>Ja</td><td></td></tr>
<tr><td align='left'>PostgreSQL</td><td>Nein</td><td>[[%2B_INTERVAL |d+ INTERVAL 'i DAY']]</td></tr>
+
<tr><td align='left'>PostgreSQL</td><td>Nein</td><td>[[%2B_INTERVAL/de |d+ INTERVAL 'i DAY']]</td></tr>
 
<tr><td align='left'>SQL Server</td><td>Ja</td><td></td></tr>
 
<tr><td align='left'>SQL Server</td><td>Ja</td><td></td></tr>
 
</table>
 
</table>
Line 36: Line 36:
 
</source>
 
</source>
 
</div>
 
</div>
 +
 +
<p>Siehe auch</p>
 
<ul>
 
<ul>
   <li>[[EXTRACT | Funktion EXTRACT]]</li>
+
   <li>[[EXTRACT/de | Funktion EXTRACT]]</li>
   <li>[[%2B_INTERVAL |Funktion + INTERVAL]]</li>
+
   <li>[[%2B_INTERVAL/de |Funktion + INTERVAL]]</li>
 
</ul>
 
</ul>
  
 
{{Languages}}
 
{{Languages}}

Latest revision as of 18:18, 21 October 2012

Kompatibilität
d + i
DBMSOKAlternative
IngresNeinwhn + date('7 day')
MySQLJa
OracleJa
PostgreSQLNeind+ INTERVAL 'i DAY'
SQL ServerJa

+ (dates)

d + i liefert ein Datum, das i Tage nach dem Datum d liegt.

 DATE '2006-05-20' + 7  -> DATE '2006-05-27'  
schema:gisq

Im Beispiel wird ein Datum 7 Tage nach dem Datumswert in whn ermittelt.

SELECT whn, whn + DATE('7 day')
  FROM eclipse
SELECT whn, whn+INTERVAL 7 DAY
  FROM eclipse
SELECT whn, whn+7 
  FROM gisq.eclipse
SELECT whn, whn+7 
  FROM eclipse

Siehe auch

Sprache: English  • Deutsch
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense