+(dates)
From SQLZoo
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 |
---|