Difference between revisions of "+(dates)"
From SQLZOO
| Line 39: | Line 39: | ||
<li>[[%2B_INTERVAL |+ INTERVAL function]]</li> | <li>[[%2B_INTERVAL |+ INTERVAL function]]</li> | ||
</ul> | </ul> | ||
| + | |||
| + | {{Languages}} | ||
Revision as of 08:35, 6 September 2012
| d + i | ||
|---|---|---|
| Engine | OK | Alternative |
| ingres | No | whn + date('7 day') |
| mysql | Yes | |
| oracle | Yes | |
| postgres | No | d+ INTERVAL 'i DAY' |
| sqlserver | Yes | |
+ (dates)
d + i returns the date i days after the date d.
DATE '2006-05-20' + 7 -> DATE '2006-05-27'
schema:gisq
In this example we show the date 7 days after the value specified in whn
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
| Language: | English • Deutsch |
|---|
