Difference between revisions of "+(dates)"
From SQLZOO
| Line 35: | Line 35: | ||
</source> | </source> | ||
</div> | </div> | ||
| + | |||
| + | <p>See also</p> | ||
<ul> | <ul> | ||
<li>[[EXTRACT |EXTRACT function]]</li> | <li>[[EXTRACT |EXTRACT function]]</li> | ||
Latest revision as of 08:52, 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
See also
| Language: | English • Deutsch |
|---|
