Arithmetic Operators
Date Arithmetic
PSQL supports adding or subtracting an integer from a date where the integer is the number of days to add or subtract, and the date is embedded in a vendor string. (This is equivalent to executing a
convert
on the date).
PSQL also supports subtracting one date from another to yield a number of days.
Examples
SELECT * FROM person P, Class C WHERE p.Date_Of_Birth < ' 1973-09-05'
and
c.Start_date >{d '1995-05-08'} + 30