Interval literal strings can be used in SQL query to manipulate Date/Time/Timestamp values. Interval literal strings can be used in date-time expression to:
• add an interval to a datetime (or add a datetime to an interval)
• subtract an interval from a datetime
Example queries of date-time expressions with Interval literals:
SELECT * FROM archive WHERE time BETWEEN now() – {INTERVAL '1' DAY} AND now();
SELECT * FROM emp WHERE hiredate BETWEEN (now()) – (interval '1' day) AND now();
