Quick Ref.
Functions
date
number
string
Data Types
date
number
string
Compatibility
d + i
Engine OK Alternative
mysql yes
oracle yes d+ i
postgres no d+ INTERVAL 'i DAY'
sqlserver yes d+i

DATEADD(d,i)

+ (dates)

d + i returns the date i days after the date d. 

 DATE '2006-05-20' + 7  -> DATE '2006-05-27'
In this example we show the date 7 days after the value specified in whn

Results
See also: