Difference between revisions of "+ INTERVAL"
From SQLZOO
(Created page with "<h3>+ INTERVAL</h3> <table align='right' border='1'> <caption>Compatibility</caption> <caption>ABS(f)</caption> <tr><th>Engine</th><th>OK</th><th>Alternative</th></tr> <tr><td...") |
|||
| Line 2: | Line 2: | ||
<table align='right' border='1'> | <table align='right' border='1'> | ||
<caption>Compatibility</caption> | <caption>Compatibility</caption> | ||
| − | < | + | <tr><th colspan='3'>d+ INTERVAL i DAY</th></tr> |
| − | <tr>< | + | <tr><td align='center'>Engine</td><td align='center'>OK</td><td align='center'>Alternative</td></tr> |
<tr><td align='left'>mysql</td><td>Yes</td><td>[[d+ i]]</td></tr> | <tr><td align='left'>mysql</td><td>Yes</td><td>[[d+ i]]</td></tr> | ||
<tr><td align='left'>oracle</td><td>No</td><td>[[d+ i]]</td></tr> | <tr><td align='left'>oracle</td><td>No</td><td>[[d+ i]]</td></tr> | ||
| Line 21: | Line 21: | ||
DATE '2006-05-20' + INTERVAL 5 YEAR -> DATE '2011-05-20' | DATE '2006-05-20' + INTERVAL 5 YEAR -> DATE '2011-05-20' | ||
</pre> | </pre> | ||
| + | <div class=params>schema:gisq</div> | ||
<div class='qu'> | <div class='qu'> | ||
Revision as of 08:36, 13 July 2012
+ INTERVAL
| d+ INTERVAL i DAY | ||
|---|---|---|
| Engine | OK | Alternative |
| mysql | Yes | d+ i |
| oracle | No | d+ i |
| postgres | No | d+ i |
| sqlserver | No | d+ i |
d + INTERVAL i DAY
returns the date i days after the date d.
You can also add YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
You can also add a negative value.
DATE '2006-05-20' + INTERVAL 5 DAY -> DATE '2006-05-25' DATE '2006-05-20' + INTERVAL 5 MONTH -> DATE '2006-10-20' DATE '2006-05-20' + INTERVAL 5 YEAR -> DATE '2011-05-20'
schema:gisq
In this example we show the date 7 days after the value specified in whn
SELECT whn, whn+INTERVAL 7 DAY FROM eclipse
SELECT whn, whn+INTERVAL 7 DAY FROM eclipse
