+(dates) - Revision history

Peter at 08:52, 6 September 2012

2012-09-06T08:52:15Z

2012-09-06T08:35:31Z

2012-07-16T15:14:46Z

2012-07-16T14:32:33Z

Compatibility
d + i
'''Engine'''	<caption>Compatibility</caption> <tr><th colspan='3'>d + i</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr> <tr><td align='left'>ingres</td><td>No</td><td>whn + date('7 day')</td></tr> <tr><td align='left'>mysql</td><td>Yes</td><td></td></tr> <tr><td align='left'>oracle</td><td>Yes</td><td></td></tr> <tr><td align='left'>postgres</td><td>No</td><td>[[%2B_INTERVAL \|d+ INTERVAL 'i DAY']]</td></tr> <tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr> </table> <h1>+ (dates)</h1> <p>d + i returns the date i days after the date d.</p> <pre style='width:80ex'> DATE '2006-05-20' + 7 -> DATE '2006-05-27' </pre> <div class=params>schema:gisq</div> <div class='ht'> In this example we show the date 7 days after the value specified in <code>whn</code> <source lang='sql' class='def e-ingres'> SELECT whn, whn + DATE('7 day') FROM eclipse </source> <source lang='sql' class='def e-postgres'> SELECT whn, whn+INTERVAL 7 DAY FROM eclipse </source> <source lang='sql' class='def'> SELECT whn, whn+7 FROM eclipse </source> </div> <ul> <li>[[EXTRACT \|EXTRACT function]]</li> <li>[[%2B_INTERVAL \|+ INTERVAL function]]</li> </ul>

@@ Line 35: / Line 35: @@
 </source>
 </div>
 <ul>
    <li>[[EXTRACT |EXTRACT function]]</li>

← Older revision		Revision as of 08:35, 6 September 2012
Line 39:		Line 39:
	<li>[[%2B_INTERVAL \|+ INTERVAL function]]</li>		<li>[[%2B_INTERVAL \|+ INTERVAL function]]</li>
	</ul>		</ul>
		+
		+	{{Languages}}

@@ Line 1: / Line 1: @@
-<h1>+ INTERVAL</h1>
 <table align='right' border='1'>
 <caption>Compatibility</caption>

@@ Line 25: / Line 25: @@
 SELECT whn, whn+INTERVAL 7 DAY
    FROM eclipse
 </source>
 <source lang='sql' class='def'>