+(dates)

Compatibility

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

• EXTRACT function
• + INTERVAL function

Language:Project:Language policy	English  • Deutsch